Date/Time Criteria Function for Query

  • Thread starter Thread starter Rita Palazzi
  • Start date Start date
R

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
 
Use ---
=Date()+0.375-1
Click to expand...

Rita Palazzi said:
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
Click to expand...
 
Rita said:
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?
Click to expand...

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

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