Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???

From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
Date: Fri, 14 Jul 2006 20:47:18 -0400

Have you tried it?

Actually, I suspect you might have to use

WHERE ([Start Day] + [Start Time]) BETWEEN (CDate([UserInputStartDate]) +
CDate([UserInputStartTime])) AND
(CDate([UserInputEndDate]) + CDate([UserInputEndTime]))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"kev100 via AccessMonster.com" <u16246@uwe> wrote in message
news:63407a6e4bccd@xxxxxx

Thanks very much.....

Since this would be with User Input (variables...) would something like:

WHERE ([Start Day] + [Start Time]) BETWEEN #[UserInputStartDate]
[UserInputStartTime]# AND
#[UserInputEndDate] [UserInputEndTime]#

...work ?

Thanks

--
Message posted via http://www.accessmonster.com

Follow-Ups:
- Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
  - From: kev100 via AccessMonster.com

References:
- Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
  - From: kev100 via AccessMonster.com
- Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
  - From: Douglas J. Steele
- Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
  - From: kev100 via AccessMonster.com
- Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
  - From: kev100 via AccessMonster.com

Prev by Date: Re: Setting DEFAULT to empty string using SQL
Next by Date: Re: my employee listing
Previous by thread: Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
Next by thread: Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???
Index(es):
- Date
- Thread

Relevant Pages

Re: I just installed Office 2003...
... "Douglas J. Steele" wrote: ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ...
(microsoft.public.access.setupconfig)
Re: Multi-Select list box on a Data Entry Form
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... I have multiple forms that the users can go to that displays ...
(microsoft.public.access.forms)
Re: Help with Microsoft help on linking Access to Outlook
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... Set MyRS = MyDB.OpenRecordset ...
(microsoft.public.access.formscoding)
Re: ignoring format/control codes exporting data from access to ex
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... If you're using it in a query, open the query in Design view, then select ...
(microsoft.public.access.externaldata)
Re: Moving files
... standard for Access: I know I move the location of MDB files constantly. ... >>Doug Steele, Microsoft Access MVP ... >>(No private e-mails, please) ...
(microsoft.public.access.security)