DSUM QUESTION

[Guest]

I am a relatively new user to Access and I have a few questions regarding the
DSUM function. I have a few tables in my database that I am trying to link
some information on. The first table contains a list of distinct order
numbers (Order Numbers Table). The second table is a transaction table that
could show each order number more than once (Transactions Table). I am
trying to do a DSUM in an update query so that it will return the sum of the
dollar totals in the "transaction" table to the "order table" with each
corresponding order number.

When I attempt to use the expression from the help menu the field that I am
trying to update doesn't return any values for any of the order numbers.

Can someone help me with this and also tell me what each part of the DSUM
expression does? Specifically, what does the _& do?

DSum("[Total - From Transactions Table]", "Transactions", "[Order Number] =
" _& [Order Number])

Thanks!

 

[Lynn Trapp]

There is no need to store the value in the "order table". You can always
query that information when you need it.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html