Search results for query: *

You are AWESOME! It works like a charm. Thanks a lot!

Yes, Entry Time could have null values as well.

Thanks for the responses. I tried PHVs response and still received errors. I'm not understanding Micheal's response. I created a public function but how am I to use this in my query? Also, are those two different possible solutions to my question?

I am trying to calculate the difference between two dates in the query, see below: Time Diff Recd Vs Entry: Round(nz(DateDiff("s",[Received Time],[Entry Time])/60,0),2) The problem is that not all of the fields for Received Time have dates in them, therefore I am getting an ERROR# in the...

Conditional formatting works for the cell I'm on in the current row, but I want it applied to the entire column in the worksheet. Any ideas on this?

I have an excel file with two date fields. Column A contains the Incident Date and Column H contains the Preliminary Date. Column A will always have a date entered and will not be deleted. What I want is for the entire row for that incident to turn red if there is not a date entered in Column...

I have an excel file with two date fields. Column A contains the Incident Date and Column H contains the Preliminary Date. Column A will always have a date entered and will not be deleted. What I want is for the entire row for that incident to turn red if there is not a date entered in Column...