Query Time/Date Problem
- From: "Georgie" <u44512@uwe>
- Date: Fri, 27 Jun 2008 14:29:14 GMT
Good Morning, I searched around and couldn't find another thread with this
particular issue so here goes...
I have a database where customers get logged in when they come into reception.
I have name, phone#, visit#, what they came in for, and an ADATE to log the
exact date and time they came in. I have a query that counts the number of
customers from 3:30pm one day to 3:30pm the next (or whatever day I choose).
I tested this extensively while I was building it and all worked perfectly
but now that I actually have it in use I found a problem. Yesterday it
worked fine but I ran it last night to view customers that came in after 3:
30pm and it included one customer from 9:42:03am. No one else from the the
rest of the day, just that one.
Qry statement:
SELECT qryMain.[phone#], qryMain.name, qryMain.notes, qryMain.[visit#],
qryMain.adate, qryMain.reception
FROM qryMain
WHERE (((qrymain.adate)>DateValue([StartDate])+TimeSerial(15,30,0) And
(qrymain.adate)<DateValue([EndDate])+TimeSerial(15,30,0)));
Anyone have any idea what could cause that or how to fix? I don't want it to
keep happening and continually skew my numbers. Greatly appreciate any
help/ideas.
Thank You
.
- Prev by Date: Re: Using ADO Recordset for Source of Access Report in .MDB file
- Next by Date: onprint at report level
- Previous by thread: Duplicated data in a report
- Next by thread: onprint at report level
- Index(es):
Relevant Pages
|
