D
DS
I have this as a field in a Query.
ELAPSE: DateDiff("n",[ChkTime],Time())\60 & ":" &
Format(DateDiff("n",[ChkTime],Time()) Mod 60,"00")
Works great! In the Criteria field I need to put this
All Records of an Elapsed Time of 15 Minutes but not less than 0
then in another Query in Criteria I need...
All records time of a 1/2 Hour or less but Greater than 15 Minutes
And in a third Query All records of an Elapsed Time of 1 Hour or Longer
So I'll end up with 3 List boxes
1) All records Open for 15 Minutes or Less But Greater than 0
2) All Records Open For 1/2 an Hour but more than 15 Minutes
3) All records Open for an hour or greater
One other question, I can't have any over lap between the three
listboxes, if it's in one it can't be in the other.
Thanks
DS
ELAPSE: DateDiff("n",[ChkTime],Time())\60 & ":" &
Format(DateDiff("n",[ChkTime],Time()) Mod 60,"00")
Works great! In the Criteria field I need to put this
All Records of an Elapsed Time of 15 Minutes but not less than 0
then in another Query in Criteria I need...
All records time of a 1/2 Hour or less but Greater than 15 Minutes
And in a third Query All records of an Elapsed Time of 1 Hour or Longer
So I'll end up with 3 List boxes
1) All records Open for 15 Minutes or Less But Greater than 0
2) All Records Open For 1/2 an Hour but more than 15 Minutes
3) All records Open for an hour or greater
One other question, I can't have any over lap between the three
listboxes, if it's in one it can't be in the other.
Thanks
DS