Parameter Query Criteria

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

Guest

Is it possible to create a criteria based on a work week number for a field
that is formatted as a standard date (mm/dd/yyyy). I would just like to
enter a work week number and not a start date and end date. Can I do this?
If so how would I write the criteria?
 
Is it possible to create a criteria based on a work week number for a field
that is formatted as a standard date (mm/dd/yyyy). I would just like to
enter a work week number and not a start date and end date. Can I do this?
If so how would I write the criteria?
Click to expand...

Add a new column to the query grid.
Exp:DatePart("ww",[DateField])

On this column's criteria line, write:
[Enter Week Number wanted]

Enter a value of 1 to 53 when prompted.

Caution, the above will return records of week # X regardless of year,
i.e week #26 of the year 2003, 2004, 2005, etc.
Is that OK?

If you need records for just a specific year, add another column.

Exp2:Year([DateField])
As criteria, write
[Enter Year]
 
Back
Top