I need help with creating a query that will take the current date and return the data from the previous week - I cannot use [start date] [end date] in my criteria because I need to create a crosstab query after I have the one week of data selected....any ideas on how I may be able to get this done?
I am trying to set up a query to search by name and by dates....I am able to let the users search by dates by letting the users enter in the dates they want to search by - the problem I'm having is the user can't remember the names they want to search by, so I can't have them search by name,is...
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.