How to query data per week

  • Thread starter Thread starter Lawlee
  • Start date Start date
L

Lawlee

Hi there,

I'm running a automatic weekly report.
I would like to know how I can query per week from Monday - Friday.
So every new week it must only take those weeks records and not for the
whole month. It will have to synchronise with the current date on my
pc.

So it will have to query 4 weeks per month that data only for the week.
The following week only that weeks data etc.

Thanks for your help.
Lawlee
 
Lawlee said:
Hi there,

I'm running a automatic weekly report.
I would like to know how I can query per week from Monday - Friday.
So every new week it must only take those weeks records and not for the
whole month. It will have to synchronise with the current date on my
pc.
Click to expand...
How do you know to which week the data belongs? Is there a date field and
if so, what is it's name?
So it will have to query 4 weeks per month that data only for the week.
The following week only that weeks data etc.
Click to expand...
This I don't understand. Do you mean once each month you want 4 weeks of
data in one report and the following week you want only a week' data? Please
be more specific.
 
Back
Top