Making an Update Query

  • Thread starter Thread starter Dos Equis
  • Start date Start date
D

Dos Equis

Hi all,

I need to make an update query but not too sure how to do it.

I need to count the number of times an item is listed in table 1 and
update a quatity field in table 2.

I have many items listed in table 1 and want them all updated in table
2.


i.e.
A=15
B=32
C=0
D=12
E=2
F=35

on down the list.

Please help,

Byron
 
If you have a way to calculate the counts, why do you need to store the
counts?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top