Help please. (1 Viewer)

[drunkwithlust]

Hello,
I have created a database for a DVD hire company. I am now creating a report based on the Hire table(Loans that have taken place) which is meant to show which should show all hires taken out for any given week and the revenue. However, I need the user to be able to enter the date from and then the system should add seven days and show all hires that have taken place in this time frame. I think i have to create a query in order to do this but im not sure. Would anyone be able to help me? Here's a print screen of what ive done so far (which doesnt work because i have no idea what to do) just incase it helps.


Thank you in advance.

 

[lightray]

Hi there, you've got the start of an idea. Yes it is best to create a query first If you want to create a calculation in a query it goes on the top line or you can create it on the page itself, best in the query though as you can run the query and see the results of what will eventually be on the report.
Something like ReturnsDue = [Date_Hired]+7

 

[boblarson]

Actually, I think you are looking for a RANGE (given a starting point and then the range between that starting date and 7 days later), am I right?

So, the criteria in your query (from your post) would be

Between [Enter Date Hired] And DateAdd("d",7,[Enter Date Hired])

But, if you do it that way you will be asked for the date twice. So, I would use a FORM with a text box to put the date into and then you can use the criteria of:

Between [Forms]![YourFormNameHere]![YourTextBoxNameHere] And DateAdd("d",7,[Forms]![YourFormNameHere]![YourTextBoxNameHere])