Hi everyone,

I am new here, also I am not an expert just a newbie but will appreciate all the help you can help me

I pulling out information from a query for a report. In this query I have three fields, "DateS", "In", and "Out". DateS is for the dates, In and out are for the start hours every day and the out is for the ending hours every day.

First I run a filter in a userform to get the dates, let's say september 6 to september 17 ( in total 2 weeks), so what I want is:

How can I have the records for the two weeks separate in the report?, so I can have the subtotal for each week two

Thank you

Welcome to the forum,

You would need to look at DateDiff and DatePart.

Or if using a report you can use groupings which will divide the data according to the date and then you can add sums, counts etc in the group header or footer.

Check out the DatePart() function in help. You can add a field to your query using it with the week option, and group on that field in your report.

Hi guys that helped me a lot, I am going to work on this at home and if I have more questions I will ask you

Ivan