G
Grizz
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
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