I created a sign-out sheet to print as a report, I am having trouble getting access to date the reports with the upcoming days any help?
I created a sign-out sheet to print as a report, I am having trouble getting access to date the reports with the upcoming days any help?
I have a table with the dates.
a form lets user pick start and end
then the query is
select * from tDates where tDates.Date between forms!myForm!txtStartDate andforms!myForm!txtEndDate
Sounds to me like you want the report to show specific dates, not show records based on start and end dates.
Either calculate the dates on the report in unbound calculated textboxes, or calculate the dates in the query and bind a text box to those query fields (better).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.