|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 13th, 2004, 01:22 PM
|
|||
|
|||
|
Form Filter by Date Range
I have a report that I can filter with a form using 5 combo boxes. Right now, I can use any or all of the comboxes in any combination. I would like to include the option to filter by date range as well. Is this possible in a form filter or only in a query?
Gale Fulton
|
|
#2
December 13th, 2004, 06:17 PM
|
|||
|
|||
|
Hi Gale,
Sure, you can use dates or date ranges to filter a report. Just include the "#" before and after your dates to tell access that it is a date and not a text string lwells
|
|
#3
December 13th, 2004, 07:51 PM
|
|||
|
|||
|
Since it will always be a date range, can I set it up this way...
Start Date: [#user enters date into text field#] End Date [#user enters end date into text field#] Thanks for your help.
|
|
#4
December 14th, 2004, 12:02 AM
|
|||
|
|||
|
Hi Gale,
If your text box is already formated as a date field it shouldn't be a problem...you won't need to enter the # sign in the text box. Place that in your report query grid. lwells
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Form Filter by Date Range |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
