#error

[Guest]

I have the following in my report field:

=DSum("trip total for graph","estimates","[program] = [obligation2] and
[start] > [forms]![report selection]![enddatevalue]")

I am getting an #error in the field. The [start] and [enddatevalue] are
dates. I think it has something to do with not translating the dates
properly. Can someone help me resolve this?

Thanks in advance,
geebee

 

[Ken Snell [MVP]]

Try this:

=DSum("trip total for graph","estimates","[program] = " & [obligation2] &
"and [start] > #" & [forms]![report selection]![enddatevalue] & "#")


Concatenate the values into the string, not the names of the field/control
where the value is found.