using a rolling date range to sum

  • Thread starter Thread starter reluctantcoder
  • Start date Start date
R

reluctantcoder

I want to use an update query to sum values of the previous twelve months. I
tried using
BETWEEN "#" & [date from] & "# AND #" & [date to] & "#"

in the criteria to limit records summed. I get a error message telling me I
did not include the and. I really would like to find a source that has the
explaination of each symbol and the parameters of the built in functions.

My dates are short date and time and always the first of the month. I have
several years of data that needs the rolling sum calculated so using a fixed
date would not work.

thanks in advance
 
reluctantcoder said:
I want to use an update query to sum values of the previous twelve months. I
tried using
BETWEEN "#" & [date from] & "# AND #" & [date to] & "#"

in the criteria to limit records summed. I get a error message telling me I
did not include the and. I really would like to find a source that has the
explaination of each symbol and the parameters of the built in functions.

My dates are short date and time and always the first of the month. I have
several years of data that needs the rolling sum calculated so using a fixed
date would not work.
Click to expand...


The And is part of the Between operator so it must be
outside quotes:

BETWEEN "#" & [date from] & "#" AND "#" & [date to] & "#"
 
Back
Top