NewCMISGrad
MIS
- Oct 18, 2004
- 13
How do I ask the end-user for a date range in a Union Query? I want to prompt by start date and end date to run query or report.
Thank You so Much,
NewCMISGRad
Thank You so Much,
NewCMISGRad
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date in SQL
- Thread starter NewCMISGrad
- Start date
- Status
PARAMETERS [Enter start date :] DateTime,
[Enter end date :] DateTime;
SELECT ....
WHERE [name of date field] BETWEEN [Enter start date :] AND [Enter end date :]
UNION
SELECT ....
WHERE [another date field] BETWEEN [Enter start date :] AND [Enter end date :]
;
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
[Enter end date :] DateTime;
SELECT ....
WHERE [name of date field] BETWEEN [Enter start date :] AND [Enter end date :]
UNION
SELECT ....
WHERE [another date field] BETWEEN [Enter start date :] AND [Enter end date :]
;
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
You, my friend, are a god.
looks like I was close, Thanks for the little push!
The PogoWolf
looks like I was close, Thanks for the little push!
The PogoWolf
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
