Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: databasegirl
- Content: Threads
- Order by date
-
Using DateDiff To Calculate Dates with Nulls
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...- databasegirl
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
Format Rows Red Based on Dates Entered in Cells
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...- databasegirl
- Thread
- Replies: 7
- Forum: Microsoft: Office
-
Format Rows Red Based on Dates Entered in Cells
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...- databasegirl
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
