Parameter Query 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?

On Thu, 2 Jun 2005 08:29:25 -0700, rwitosky wrote:

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?

Add a new column to the query grid.
ExpatePart("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]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.