Does anyone have ideas on how to get a Month to Date total from a query using (1) date?
example:
I enter 3/5/2011 in a form and the query returns the totals for every entery in a field back to 3/1/2011.
Does anyone have ideas on how to get a Month to Date total from a query using (1) date?
example:
I enter 3/5/2011 in a form and the query returns the totals for every entery in a field back to 3/1/2011.
You should find a function to find the first day of the month here:
http://www.pacificdb.com.au/Support/...hfunctions.htm
That and a Between clause should get you your result.
That worked great. Thanks for your help.
No problemo; there are a lot of handy functions there.