extract monthly dates using a query to a table 1

[wattyl]

Hi out there,
How can i find records that are due updates in a certain month using a query.
The query has Location/Number/Name and the due date as column headings but I cant work out the criteria required to extract the due dates anybody any ideas

 

[sko]

Replace your date column with an expression that extracts the number representing the month in your date field.

Field:
MonthDue:Month([NameOfYourDateField])
Criteria:
[Enter the number representing the month due.]

Or, if you want the user to enter an abbreviation

Field:
MonthDue:Format$(Month([NameOfYourField]),"mmm&quot

Or, if you want the spell out the month

Field:
MonthDue:Format$(Month([NameOfYourField]),"mmmm&quot

 

[sko]

Ooops! Ignore the second part of my post. It should be..

Field:MonthDue: Format$([YourDateField],"mmm&quot

got a little carried away, sorry.

 

[wattyl]

Tremendous it works a treat, many thanks for your help