Date Between Problem after changing table
- From: Grizz <Grizz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 17 Dec 2008 21:31:00 -0800
There was a mistake on one table that had 2 fields named DATE and TIME, Date
was using Date() and Time was using Now(). I changed the fields to one
field, named CallInDateTime formatted "mm/dd/yyyy h:nn AM/PM" on the
form it is =Now() it works slick for the form and couple of reports. My
problem is I think this change messed up one Query where it was a Date
Between criteria. Could this between selection be asking for the time too?
If it does How to seperate just the date? There is about that many spaces in
between each of the formats too. Or could it be in the criteria code.
WHERE (((CallInTbl.CallInDateTime) Between [Enter First Date selection] And
[Enter Last Date Selection] And (CallInTbl.CallInDateTime)="!NULL"));
Thank You for your help on this
.
- Follow-Ups:
- Re: Date Between Problem after changing table
- From: Allen Browne
- Re: Date Between Problem after changing table
- Prev by Date: Count unique field1 combined with count field2, both grouped and ungrouped
- Next by Date: run sum
- Previous by thread: Count unique field1 combined with count field2, both grouped and ungrouped
- Next by thread: Re: Date Between Problem after changing table
- Index(es):
Relevant Pages
|
