I have the following feilds in a query: Timein Timeout
I need a subtotal feild that totals the two across midnight
I also need a Lunch feild
Then I need a total feild with the subtotal and total subtracted
I tried using this expression please help anyone if you can
Format([Timein] -1...
Thanks
Thanks for the advice and the warm welcome. My question is this. My relationships are created among the three tables but they are all one to one. I think I would need to change to one to many only the index would be changed throughout. Is there another way to construct the tables that...
Hello everyone. I have a quick question. I am creating a staffing database for a nursing staffing agency. At present I have 3 tables: Enter/New nurses, Facilites, and Schedule a nurse. The schedule a nurse table is linked to Enter/new nurse by Nurse's name feild and to the facility feild by...