Only show data in query from present time to 2 hours prior.

[MFS]

Hello all,
I've been working on my database pretty hard over the last few days and asking for a lot of help on this forum. One thing I found out is that sending 'time' to the DB in a text format can mess a huge amount of stuff up when trying to query a time field. So recently I had someone help me with

ConvertedTime: CDate([Time1])

However, Now all my old code that June7 and others have helped me with does not work, so yes, I'm somewhat starting over with my query design.

What I'm asking for in this thread is support writing code in my query criteria to only show data for the past two hours from the present time. (No matter what time I open the Query. Only show past two hours of data from that time)



Mike

[orange]

Use Google with these terms.

1) techonthenet Access now
2) techonthenet Access DateAdd

These will show you the purpose and syntax with examples.

Something like this (substitute your fields and table name as appropriate)

Select yourdata from yourTable
Where ConvertedTime Between Now and DateAdd("h", -2, Now)

[MFS]

orange,
Yes I've tried, Between Now and DateAdd("h", -2, Now), and I get a message box stating "Invalid use of Null".

[JoeM]

Do you have any Null entries in your ConvertedTime field?

[MFS]

Yes, I do.
I'll look in my table and add a time or if they are not required I'll delete them, and then get back with you

[lfpm062010]

the syntax is, the dateadd syntax looks right. the now() is a function call.

Between Now() and DateAdd("h", -2, Now())

[MFS]

My solution to this problem.
My tables are now not allowed to have NULL values in the Date and Time Fields.
So far everything is looking good.
Thanks To All For The Support

[JoeM]

Your welcome.
Sounds like a good plan!