Update Query - I can't count

[muster101]

Greetings,

Sorry for the novice questions but....

I have 2 tables that I have joined on a field 'npanxx'

The 1st table has one unique occurance of each 'npanxx'
The 2nd table has multiple occurances of each 'npanxx'

I have a field in table1 that I want to populate with the count of occurances of 'npanxx' in table 2


table1
'npanxx' 201201

table2
'npanxx' 201201
'npanxx' 201201

the field i then want to update in table1
'count' 2

I have tried this thru the design update query method and just don't get it !

Secondly, it's probably obvious this is new to me and i doubt i even qualify as 'beginner'. Any suggestions for a book I could get that would best help me with learning Access?

Thanks for any help!

 

[Parra]

Its simple to get the "Count"of npanxx in table 2

Just create a query, add the field npanxx Twice to the query. Click on the toolbar on the sum icon (it looks like a big letter E), then look back where the second field is, where is says grouped, click on their and change the criteria to Count. So you will have 1 that says grouped and another that says count. Run the query it will give you the result you are looking for.

I have to think about how you'll get this result to table one, but why would you want to do that?