Sorry I wasn't more specific. On the main Form of the database, there are several options available to management to run different reports. For the reports to pull accurate information, the criteria set in the query has to be
Between Dec-01-01 AND Dec-30-01.(or whatever month we are currently...
I have a query that currently requires manual input of the first and last day of the month to execute the query (i.e. dec-01-01 and dec-31-01). Does anybody know how I can add a criteria (I know zero about SQL or codes) that automatically makes it Between first AND last days of the current...
I have my answer. A colleague in my office helped me out. The critria in the date field should be:
Between DateAdd("d",-7,Date()) And DateAdd("d",-2,Date())
I am running the macro on Mondays, so this will give me all the pertinant info from the previous work week (Monday-Sat)
This is a start. Do you have any idea how I can make Access automatically calculate it. I.e. when I run the query, it automatically gives me the results from the last 7 days without any input??
I am new to access and have a query that links 3 tables. It is a pretty simple query but I need to make the date field criteria pull only information from the last week. I can manually change the criteria every week, but I want to have it automatic so that it can be added to a weekly macro that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.