Query Criteria

[bibstar03]

I have a table which contains data on different dates. When i run a query i need to be able to show the data for that week. I can use criteria which looks like this

>1/07/04 And <7/07/04

but the dates must be entered each time. i need a way that when the query is run, the dates for that week are shown.

Thanks for any help

Bibstar

 

[Ziggy]

I tested the following, I'm sure there are other ways but try this:

Paste the following into a new field in the query grid (put in your date field)

WeekNumber: Format([YourDate],"ww")

That expression will return the Week number, check for yourself on a calender.

Now in the criteria place the following:

Format(Now(),"ww") And Year([YourDate])=Year(Now())

The criteria is using the week number of whatever today's date ( the date query is run), plus is only returning the current year other wise you'll get other years returned.


It works let me know if you have any problems

Ziggy