RE: How to get records from this month and only this month

SELECT quantity_nb FROM tblDailyNumbers nb WHERE DateDIFF(mm, #CreateODBCDate(Now())#, getDate()) = 0 AND DateDIFF(yy, #CreateODBCDate(Now())#, getDate()) = 0 The syntax of this may be wrong but I'm pretty sure you want something more like this SELECT quantity_nb FROM tblDailyNumbers nb

RE: How to get records from this month and only this month

use the BETWEEN operator in your SQL statement and use the first and last of the month. -Original Message- From: John Barleycorn [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 11:58 PM To: CF-Talk Subject: How to get records from this month and only this month Hello, i need to