I have a DB that in one of the tables is a field titled "StartDate". I would like to create a report that when opened it shows only the data in the table that is the current date. Is this possible? Do I have to base a report off of a query that is set up to show that? If so how?
OK-- I believe I am starting to answer my own question. I still need help though. It seems as if I should be able to set an "=Date()" in the criteria of the start date within my query and then when ever the query is ran, the current system date will then be....well queried. However, when I do this I receive an error stating, "Type mismatch in expression".
Help?
Please?
I was on the right path....I figured it out. Hooray me!