Dsum, Syntax error

[mike02]

Hey, I am trying to run this Dsum function:

RunTot: Format(DSum("[Monthly_Sales].[UnitsSold]","Monthly_Sales","[Monthly_Sales].[CompanyID]='" & [Monthly_Sales].[CompanyID] & "' And [Monthly_Sales].[MonthlyDate] <=#" & [Monthly_Sales].[MonthlyDate] & "#"),"00.00")

I use to have it set up on text and Date, but i am changing it to Numeric, CompanyID, in stead of CompanyName and Date as well.

thanks in advance,

[rzw0wr]

RunTot: Format(DSum("[Monthly_Sales].[UnitsSold]","Monthly_Sales","[Monthly_Sales].[CompanyID]='" & [Monthly_Sales].[CompanyID] & "' And [Monthly_Sales].[MonthlyDate] <=#" & [Monthly_Sales].[MonthlyDate] & "#"),"00.00")

I think you need to put something in place of the , (comas) ( + - * / )

If you are intending on using them as all to get some total.
I am not sure this will work if you are trying to get a sum for each field.

Dale

[mike02]

i need the totals to continue to sum, that way i can create a graph showing the growth

[rzw0wr]

i need the totals to continue to sum, that way i can create a graph showing the growth

Meaning you need individual totals for each field. Correct?

If so I think it will require a Dsum() function for each field.


Dale

[ssanfu]

If "CompanyID" is numeric, it doesn't require delimiters. Remove the single quotes for "CompanyID"

Try this:

RunTot: Format(DSum("[Monthly_Sales].[UnitsSold]","Monthly_Sales","[Monthly_Sales].[CompanyID]=" & [Monthly_Sales].[CompanyID] & " And [Monthly_Sales].[MonthlyDate] <=#" & [Monthly_Sales].[MonthlyDate] & "#"),"00.00")

[mike02]

thanks! worked!