View Single Post
  #1  
Old November 16th, 2004, 05:04 PM
RusCat
external usenet poster
 
Posts: n/a
Default 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.