Select last hour of data in Access query

Question

I want to pull data for the last hour or two from a table but the data field and time field are separate fields.

The field "date_stamp" is a Date/Time field but the "time_stamp" field is short text. I cannot find a way to combine these to grab my data for the last hour.

Thank you!

Answer 1

Hi,

If you have valid formatted time data in your text field then you should be able to use this in a query:

date_stamp+CDate(time_stamp)

and as criteria for the last 1 hour: >=DateAdd("h",-1,Now())

If that doesn't work then describe the error and show examples of the data in the text field.

Servus
Karl
Access News
Access DevCon