Recent content by Veron
-
V
Working days query
EMP, A very simple, effective expression! Just wonder if we can modify Jon K's expression to return the number of working days, not counting StartDate as the first day, too. Veron -
V
Forms!myForm!myControl OR Forms!myForm!myControl Is Null
Thank you very much. That worked. -
V
Forms!myForm!myControl OR Forms!myForm!myControl Is Null
Found a link for building search criteria: http://www.mvps.org/access/queries/qry0001.htm [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null Thought it would be easy. In the ContactTitle and City columns, I put in the criteria: forms!frmSearch!txtTitle or... -
V
left() of decimal?
Thanks a bunch. With your expression of Sum([TimeEnd]-[TimeStart])*24, what used to be half an hour's work in Excel is now reduced to less than one second with an Access query. It's amazingly simple. No complicated divisions and multiplications. I appreciate your help. Thanks again. -
V
left() of decimal?
Jon K I wonder if you can help me with my problem. By adapting your expression in a Totals Query, I was able to correctly get the workers' weekly [Total HHMM] Int(Sum([TimeEnd]-[TimeStart]))*24+DatePart("h",Sum([TimeEnd]-[TimeStart])) & Format(Sum([TimeEnd]-[TimeStart]),":nn") AS [Total HHMM]...