query Last month records

J

Jeff

Hello! Does anyone know how do find records from the previous month? (e.g. February) In the Joining Date field I have used the input mask 00/00/0000.

Field : Joining Date
Table : tblStuden
Criteria : Month([Joining Date]) -

Would be greatful for any help thankyou!
 
C

Cheryl Fischer

answered in: microsoft.public.access.queries

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Jeff said:
Hello! Does anyone know how do find records from the previous month?
Click to expand...
(e.g. February) In the Joining Date field I have used the input mask
00/00/0000.
Field : Joining Date
Table : tblStudent
Criteria : Month([Joining Date]) -1

Would be greatful for any help thankyou!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time format hh:nn drops leading zero 0
Differents totals for each year of birth within a Field. 3
What are the proper Criteria for a Field? 3
Using DateAdd and IIF conditions in a Query 2
Find Last Month Records 1
Properties - Format, Input Mask, Validation Rule 5
How to build a "reach around" query? 5
Looking for criteria in query that filters based on last month'srecord date 11

Top