Time() reference in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm trying to return a list of today's or yesterday's events based on
system time, whether before or after 9 AM. I put
=IIf(Time()<0.375,>Date(),>Date()-1) in the column criteria and get no
results. I put the same kind of criteria in another column, i.e.
=IIf(Time()<0.375,"gregsales","tomsales") and I get the correct results
(true vs false).
I can also put >Date() in the criteria field and pull the day's events.
The >Date and the before or after 9am seem to work separate, but not
together. Any suggestions?
 
Thank you very much for the reply. I am new to this and could not find this
one, so I had re-posted. I tried using the statment you put, but since the
data is in date/time format, it won't return anything without >Date(). I
guess it assumes Date() meaning midnight. Thanks for the help on this, it's
driving me nuts!
 
I am not sure if my previous post answered your question from your last
post???

If you still need help, explain your set-up with some sample data, what you
want to achieve and the example of this from the sample data.
 
Back
Top