Dates in a listbox connected to a form...
Good morning,
Here is something I'm tryng to do, but can't seem to get a handle on. I am
hoping for some direction.
I have the following things listed in a listbox: today, this week, this
month, last week, last month, custom
I want to be able to click on THISWEEK and have all the records for this
week to show up on my form.
It is a projects table where our employees log in the hours they have spent
on a project. I need them to be able to see the data by the choices above.
ALSO: how would I create a CUSTOM set of data? Click on CUSTOM, some sort
of boxes appear where I could type in the 2 dates and everything between
those dates would show up on the form.
I've tried queries, but I'm just not getting it. I understand the logic
behind it, but just not how to get it done. I'm a novice Access user, so
please be gentle in your help and explainations !!
Thank you so much.
LisaB.
|