query Last month records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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...
 
Back
Top