How to query data per week

[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

 

[Guest]

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.

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.

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.