calculating a field in a query to add 16 days to the last departure date record

[TLCTech]

I need to be able to see when a customer can come back. They need to not come back for 16 days after their last date that they were in.

[Perceptus]

If you add a number to any date, it will add those many days.

#3/8/2016# + 16 = #3/24/2016#

[orange]

They need to not come back for 16 days after their last date that they were in.

??Need not ===> must not

EarliestNewdate = DateAdd("d",16,LastVisitDate)

[TLCTech]

would this be put in the design view of the query. In the criteria box for the new entry of EarliestNewDate

[TLCTech]

Here is my database that I need help with. I would like to have a query that checks for the next available date that the camper can come back in. It could be put in the qryLicenseSearch if possible to keep from having to run several searches. I have a switchboard made to run the different forms and queries that I have made.



Database Spreadsheets.zip