Why not ? access foresee that you can add records along queries.
I looking for the next solution. I got one query with only the new records of today. But I like if the user did not close a record (he or she forgot to put a time in the previous days) that he show this records to. I try to fix this along the where condition.
So is your form bound to a union query? How is access supposed to tell which table to insert the records into?
Try this parameter if you want to get the last two days worth of rows to show up:
Code:
where [DateColumn] >= DateAdd('d', -1, date())
You can of course change the -1 to -7 if you want the last week's records, and so on. If you want to get really crazy, you could add a combo box allowing the user to select how many days back to make available.
Are you storing rows in a new table each day? I don't see why a union is necessary.
Good Luck,
Alex
Ignorance of certain subjects is a great part of wisdom
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.