Date/Time Criteria Function for Query

[Rita Palazzi]

Windows XP Professional
Office 2000

I have a table in Access with a datetime field. I need to only show
those records where (datetime >= yesterday's date at 9 pm). Does anyone
know the correct expression to put in the criteria statement of my query
to accomplish this?

Thanks for any help!!
Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express

 

[Guest]

Use ---

=Date()+0.375-1

Windows XP Professional
Office 2000

I have a table in Access with a datetime field. I need to only show
those records where (datetime >= yesterday's date at 9 pm). Does anyone
know the correct expression to put in the criteria statement of my query
to accomplish this?

Thanks for any help!!
Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express

 

[MGFoster]

Windows XP Professional
Office 2000

I have a table in Access with a datetime field. I need to only show
those records where (datetime >= yesterday's date at 9 pm). Does anyone
know the correct expression to put in the criteria statement of my query
to accomplish this?

In the SQL view set the WHERE clause to something like this:

WHERE datetime_column >= DateAdd("d", -1, Date()) + #09:00#