Show report for today only

[cooper]

Hi,



I have a report which has a multiple text boxes. These text boxes show the sum of different values that were entered in table.

Users log in everyday and fill in the information in the form, which saves the date in the table and then I used a query to form a report.

but I want to display only "Current date" information - how do I do that? Also, I don't want them to ENTER the date themselves. I used date() function in my form to pull out todays date as well.

I tried to put "<=Current_Date" as the criteria for dte in the query but that gives an error saying "Data mismatch"

any ideas?

thanks!

[pbaldy]

Try just putting this in the criteria:

Date()

Note that sometimes Access will drop the parentheses, which I wouldn't worry about.

[cooper]

brilliance! worked. thank you so much!

one thing though - sometimes the user might want to see reports for other days as well. I guess I could use Between[startdate] And [end date] right? but how do I incorporate both options as "today" or for other days?

[pbaldy]

Personally I almost always use a form to have the user input the criteria. In this case, you could do that and default both textboxes to today's date.

[KrisDdb]

Hey Cooper

I have used something like this very recently. so i thght this might help you out. Design a form with a couple of text boxes.. for Start date and End date. Then put the following code in the control sources for each of them:

=[Forms]![yourFormName].[txtStartDate]
=[Forms]![yourFormName].[txtEndDate]

When user wants to see reports for other days as well, this will let you give the start date and end date. Make sure you give the same code for the date range in the query criteria that fetches your data. And like Paul already said, you could default them to Date(), so when you dont specify a date range, it returns "today" like you want it to.

HTH

[cooper]

wow sorry for the late reply!! thanks alot buddy!! really appreciate it

[pbaldy]

Happy to help, if it was me that helped.