Date logic

[drunkenneo]

I have a date stored, lets say 22/07/2013, and i have a table with entry date, and ordernumber.

i want to write a count of all the ordernumbers they were in month of july i.e from taking month and year from current month, from coding.
Thanks in advance..

[JoeM]

Do you mean something like this?

SELECT Count(MyTable.OrderNumber) AS CountOfOrderNumber
FROM MyTable
WHERE (((MyTable.EntryDate) Between #1/7/2013# And #31/7/2013#));

[JoeM]

Or, if you are getting your month and date from some variable or fields somewhere, this may work better:

SELECT Count(MyTable.OrderNumber) AS CountOfOrderNumber
FROM MyTable
WHERE (((Month([MyTable]![EntryDate]))=7) AND ((Year([MyTable]![EntryDate]))=2013));

If doing it from VBA code where you are building the SQL code from some form fields, substitute those in for the hard-coded values of "7" and "2013".