Help with Dsum,please!!!

[PQTIII]

I'm not sure how to use the dsum function. I have a form where the daily info is entered. Once the info is entered I need to display the total number of units used todate. I was told to use the dsum function. Here is my attempt, but I keep getting an error. I have the entry form in the form details and put a text box in the form footer. This in the control source fields :

=DSum("[units]","inventory","[invent type]='Used' ")

What am I doing wrong and how do I fix it?

Thanks

 

[PHV]

I keep getting an error
Any chance you could post the whole error message ?
Which line line highlighted when in debug mode ?
If the form is a continuous one, you may try to use Sum instead of DSum:
=Sum([units])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PQTIII]

PHV

I'm very new to using forms in Access, so I'm kind of lost. Not sure what you mean by continuous form or how to use the debug mode. What I have is a form that the user enters data once a day everyday. After that data is entered I need to display a running total of the units used. I have no clue of how to do that on a form. Can you tell me the easiest way to do that, please?

Thanks for your help.

 

[PHV]

Again, which error when trying this ?
=DSum("[units]","inventory","[invent type]='Used'")

Is inventory a table ?
Is units a numeric field in that table ?
Is [invent type] a text field in that table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PQTIII]

In the form field it just shows #Error

-inventory is a table
-units is a numeric field
-invent type is a text field