Link to home
Start Free TrialLog in
Avatar of Dan89
Dan89

asked on

Todays date criteria

I have a basic query where one of the fields is a date, what criteria statement do i need to use to give results where that date matches the current date,

Cheers
Dan
ASKER CERTIFIED SOLUTION
Avatar of omgang
omgang
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I do not agree.  omgang had a perfectly usable answer.  The 'Accepted Solution' is nothing more than another way to skin the cat - and in Access there are often several ways of saying the same thing.  The rule is the first correct answer gets the cookie.  You chose the second.
Thanks GRayL.  I was so proud of myself for finally answering a question ahead of DatabaseMX :)  Then he one-ups me by getting his answer accepted over mine :(

What can I say?  He's just better than I am ;)
OM Gang
Avatar of Dan89
Dan89

ASKER

Sorry OM, the reason is, i thought i had tried your solution earlier, hence why i asked the question, i must have mistyped it in at that time though. Your solution does work, sorry for the mess up, any way to swap around the points?

Dan
Just an fyi here ...when I brought this Q up, there were *no* other posts at that time.  However, someone came into my office just as I had started to type that answer.  When they left, I added the reaming characters and hit submit. So, in fact, I was *not* trying to one-up anyone. It wasn't till later in the day that I even saw gRay's post, at which point I assumed it would be taken care of.

mx
It was;-)
If course, there is a subtle difference in the answers ... mine takes into account Time ... so if ... that mattered to his particular case ... that well, it would matter :-)

mx
mx - I am really hoping you know my comments re. you were in jest.  If I we can't have some fun here, well......it take's some of the fun away.......  You know what I mean.
OM Gang