Add up text boxes from last 7 Days

[joeydeck]

Hello,
I have a booking form and i would like to create a report on how much all the bookings have made over the last 7 days. I have a DateBooked field which is the day is has been booked, i assume you might use this. All the calculations is done in a text box on the form for each record.

Have any of you got any ideas?



Thanks
Joe

[wrkadri]

>= Dateadd("d",-7,Date()) shoud do the trick.
Use it in the Query criteria.

[joeydeck]

Thankyou



Joe

[wrkadri]

You're welcome