What in the World is wrong with my DSUM

[Bill Bisco]

BaseSum: DSum("ElementTime","tblElements","OptionID = BASE")

I'm getting an Error from Access when I thought I was inputting information in correctly as per the help file on DSUM.

I want to Sum up all the records of the ElementTime field from the Table tblElements, when those Records' OptionID Fields say BASE.

When I use this in a query I get an Error stating

"The expression you entered as a query parameter produced this error: 'Microsoft Office Access can't find the name 'BASE' you entered in the expression'

Any Help is appreciated.

Sincerely,
Bill

 

[Alc]

Have you tried putting Base in quotes?

e.g. BaseSum: DSum("ElementTime","tblElements","OptionID = 'BASE'")

 

[MSAccessRookie]

BaseSum: DSum("ElementTime","tblElements","OptionID = BASE")

If OptionID is Type Text, you might want to try this:

DSum("ElementTime","tblElements","OptionID = 'BASE'")
​

 

[Bill Bisco]

Thanks guys, that did the trick.

I appreciate it,
Bill