Query criteria

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I fear this is a dumb question, so apologies in advance. For the life of me,
I can't get anything to work.

I need to figure out a simple formula for a criteria to drive a query. I
have two seperate date fields (C_Month and C_Year). Month is shown as 01,
02, etc and Year is 4 digit year. Both are text fields...

The criteria I need is to select ONLY the current month/year based on when
the query is run - so for today, i'd only want Aug 09 records.

Thanks in advance for any help...
 
You should use a REAL DateTime field and display it as needed.
Your fields -- C_Month C_Year
Criteria -- Format(Date(),"m") Format(Date(),"yyyy")
 
Format(Format(Date(),"m"),"00") for Karl's example for month since you need
01 for January
 
Back
Top