DSum in Query

  • Thread starter Thread starter Con Giacomini
  • Start date Start date
C

Con Giacomini

I would like to learn the syntax to enter a DSum function within a query
where the criteria for the DSum is the ClientID field displayed in the query
grid, such as the following expression:

Sum("[Field]","
","[ClientID]=[This Query's ClientID]")

I would like the expression to produce the sum totals for each client in the
query.

Is this possible to do? Thanks for any help.
 
To use DSum(), try:
DSum("[Field]", "
", "[ClientID] = " & [ClientID])
This assumes ClientID is numeric. If it is text, then try:
DSum("[Field]", "
", "[ClientID] = """ & [ClientID] & """")
You could probably also use a subquery
(Select Sum([Field]) From
T Where T.ClientID =
.ClientID)
 
Thanks a lot Duane. It worked perfectly!

Duane Hookom said:
To use DSum(), try:
DSum("[Field]", "
", "[ClientID] = " & [ClientID])
This assumes ClientID is numeric. If it is text, then try:
DSum("[Field]", "
", "[ClientID] = """ & [ClientID] & """")
You could probably also use a subquery
(Select Sum([Field]) From
T Where T.ClientID =
.ClientID)


--
Duane Hookom
MS Access MVP


Con Giacomini said:
I would like to learn the syntax to enter a DSum function within a query
where the criteria for the DSum is the ClientID field displayed in the query
grid, such as the following expression:

Sum("[Field]","
","[ClientID]=[This Query's ClientID]")

I would like the expression to produce the sum totals for each client in the
query.

Is this possible to do? Thanks for any help.
Click to expand...
Click to expand...
 
Back
Top