Month To Date Query

[jmorse]

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.

[pbaldy]

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.

[jmorse]

That worked great. Thanks for your help.

[pbaldy]

No problemo; there are a lot of handy functions there.