enter group totals based on another table

M

Magdalena

In MA database I have 2 tables - Products and Deliveries - linked by key
field ProductCode. The same product can be delivered many different times. In
the table Products I want to enter the total number of each product. (i.e. 10
pieces of product A was delivered 4/10/04 and 23 pieces of product A on
12/11/04. In the table Products I want to have 33 in the product A record) At
the moment I'm trying to use the DSum function in the update query but it
doesn't do work. This is what I have:
Field: UnitsInStock
Table: Products
Update To: DSum("[NumberOfUnits]","Deliveries","[ProductCode]=" &
[ProductCode])
Criteria:

Please help me!
Magdalena
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update UnitsInStock 9
Update field on table, with value from 2nd table from form 4
table based i one field splitted in 2 fields 6
Most recent delivery date 1
Append more values 5
Multi join on same table 0
Blank Fields in Report 2
Making a Pivot chart from 3 differnt sets of data / worksheets. 0

Top