Periodic Query

[BigCat]

I am developing a procedure to query the same information from my table each month.



So I was wondering if there was a statement I could add to my query statement that will grab only the records where the dates in the date column are within the current month.

Something like 'WHERE [MFG COMP] = current month' or something along those lines.

[ajetrumpet]

use the MONTH() function. "where month(field) = month(date)"

are you serious with this??

you've been posting here for a while now....these are very basic functions in Access. How long have you worked with this program??

kinda seems like some of your ?'s could be answered by simple google searching. are you a business owner and not have time to do this? just curious...

[BigCat]

I guess I was unclear in my first post. I am making a procedure that I can just run at the end of the month so I wanted to know if there was a functionwhere it compare the field to the current month without having to go in and specify the date myself in the query string.

[pbaldy]

I would not use the Month function (without accounting for year). I'd use Between and the appropriate functions from here:

http://www.pacificdb.com.au/Support/...hfunctions.htm

[ajetrumpet]

I would not use the Month function (without accounting for year). I'd use Between and the appropriate functions from here:

http://www.pacificdb.com.au/Support/...hfunctions.htm

agreed. also agreed that I'm off on this one.