enter group totals based on another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can't do calculations in Access tables. It might look like a
spreadsheet but it's not.

Here's an excellent explanations and some examples.

http://members.iinet.net.au/~allenbrowne/AppInventory.html

Brett


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
Click to expand...

Cheers,
Brett
 
Many thanks Brett. I have now managed to overcome the problem.
Magdalena

Brett Collings said:
You can't do calculations in Access tables. It might look like a
spreadsheet but it's not.

Here's an excellent explanations and some examples.

http://members.iinet.net.au/~allenbrowne/AppInventory.html

Brett


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
Click to expand...

Cheers,
Brett
Click to expand...
 
Back
Top