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.
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.