W
WSF
Access97
I wish to:
1 - hold a FirstQryTime (not date/time - just the time) when a data
query [Qry1] is run and hold that time as a reference for the duration of
the current session, without having to write it to a table.
I then wish to calculate the time difference in minutes between that time
and a second query [Qry2] being run - say SecondQryTime.
2 - If the second query is run before the first (that implies the
FirstQryTime is "" or Null or 0 ?) I want to present a MsgBox to the
operator and exit the routine.
I have tried several ways of doing it but get stuck on data types, and have
also ended up with a 6 - Overflow error message (2 above).
Seems simple but I can't get my head around it.
TIA
WSF
I wish to:
1 - hold a FirstQryTime (not date/time - just the time) when a data
query [Qry1] is run and hold that time as a reference for the duration of
the current session, without having to write it to a table.
I then wish to calculate the time difference in minutes between that time
and a second query [Qry2] being run - say SecondQryTime.
2 - If the second query is run before the first (that implies the
FirstQryTime is "" or Null or 0 ?) I want to present a MsgBox to the
operator and exit the routine.
I have tried several ways of doing it but get stuck on data types, and have
also ended up with a 6 - Overflow error message (2 above).
Seems simple but I can't get my head around it.
TIA
WSF