comparing dates

L

Linda

I have the following expression with several dates but
I'm getting a syntax error message:

The expression should make a sum if the comparison of the
dates is true. Searchnumber is a string and dminst,
dtstart, dmaxst and dtend are all dates.

inttotal = DSum
("[Total]", "detailsadsl", "[CallingNumber] = '" &
searchnumber & "' And #" & dminst & "# >= #" & dtstart
& "# And #" & dmaxst & "# < = #" & dtend & "#")

TIA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top