I am creating reports using query and use "where" and input a criteria "Between [Enter Start Date] And [Enter End Date]"
the user has to input the date to get the reports. I want it to be automated that as soon as its the report is opened it only pulls that days report.
is there a way to check the systems date and time and use that as input
Similarly for monthly reports instead for manually inputting the dates for the month. check which month it is on the system and display that months reports.