Hey everyone. I need some help with displaying totals in the header on a continuous form.
I am working on a project to keep track of how many people enter and exit the building each hour every day at 4 different entrances.
Table has the following columns
ID, c_date, hours, entrance1_in, entrance1_out, entrance2_in, entrance2_out, entrance3_in, entrance3_out, entrance4_in, entrance4_out
What i am trying to do is display the total amount of people that entered and exited the building per shift (between certain hours between 7am and 2pm for example or between 3pm and 10pm) in unbound textboxes in the header of a continuous form.
any help would be greatly appreciated.
I am working on a project to keep track of how many people enter and exit the building each hour every day at 4 different entrances.
Table has the following columns
ID, c_date, hours, entrance1_in, entrance1_out, entrance2_in, entrance2_out, entrance3_in, entrance3_out, entrance4_in, entrance4_out
What i am trying to do is display the total amount of people that entered and exited the building per shift (between certain hours between 7am and 2pm for example or between 3pm and 10pm) in unbound textboxes in the header of a continuous form.
any help would be greatly appreciated.