S
Song Su
I have a form based on following query
SELECT qryData.SID, DateDiff("n",[timein],[timeout]) AS Minutes
FROM Duration, qryData
WHERE (((qryData.timeIn)>=[from]) AND ((qryData.timeOut)<=[to]+1));\
On the form, I want only 3 text boxes:
1. Uniq SID count
2. total recound count
3. total hours
Thanks
SELECT qryData.SID, DateDiff("n",[timein],[timeout]) AS Minutes
FROM Duration, qryData
WHERE (((qryData.timeIn)>=[from]) AND ((qryData.timeOut)<=[to]+1));\
On the form, I want only 3 text boxes:
1. Uniq SID count
2. total recound count
3. total hours
Thanks