Search results
-
A
help with conditional sum on report
I have a report where BWTID is grouped. I have the summary total in the footer for EMPDH (employee hours). I am trying to create a summary list of each bwtid and the total hours for that btwid. I tried this and it worked beautifully for the first one: =IIf([bwtid]=2,[Text26],0) but... -
A
Complex Report help needed
I have a table of employees. Each employee has records for work done in 3 different projects. I want to create a report that sorts on Employee name, then lists all the entries for project 1 , then all the entries for project 2, then all the entries for project 3. Each project is a separate... -
A
Solved Create a NEW subform record for existing Record.
I have a form where we track the work the employee is doing. The main form works well and updates well - however if they close the form and work on something else for a bit then come back and restart working this i need to retain the Main record id and the date (easy enough, a query drives... -
A
Solved Time stamp at update and record exit.
I have a form that records time() when the record is started. I would like to have it also record the current time when the record is exited. I need to be able to identify how much time has elapsed from the start of the record to the exit of the record. Start Time =time() how do i get the... -
A
open last data entry record for a specific person and a specific date.
I have a form that multiple people use - i need to isolate them from each other, so DoCmd.GoToRecord =acLast is not an option because the last record may not have been their record.... if they open the form and begin entry and close the form .. then reopen the form to continue entry it... -
A
Help - possible re-structure - wonky data output
I have a form that employees fill out to track their work. I need to be able to get the total time they worked, the detail of what case numbers they processed and a count of how they were processed. Easy enough, right? NOT ! If they do not close and reopen the form for the day ... -
A
Solved Help with column of hours and minutes summing as hh:mm
I track the time spent on a task in hours (as number) and minutes (as number) . A person may have 7 entries in a month. I need to be able to show total hours and total minutes on the report per each employee. Currently, i have a calculated field that takes my hours and converts them to...