Im running a query that sums the costs occuring from 1/1/2003 to a year entered by the user in a form. So right now the critieria in my query looks like this:
between #1/1/2003# and [forms][myForm][date2]
Which works fine. But i want the query to work for any year, right now it will work for only the year 2003.
Any suggestions???
between #1/1/2003# and [forms][myForm][date2]
Which works fine. But i want the query to work for any year, right now it will work for only the year 2003.
Any suggestions???