SuperbHosting.net & Arvixe.com have generously
dedicated servers and web hosting to ensure
a reliable and scalable dedicated hosting
solution for BigResource.com.
Military Watchbill Creator
I am trying to create an automated watchbill creator.
Watches (for those that dont know they can be treated like shift work).
We stand 2 differant watchs a day.
8 hours watchs. 1 starts @ 1600., 1 starts @ 0800.
We are in 4 sections - so that mean each section has about 20 people.
10 that can stand the first watch, and 10 that can stand the second watch.
Currently I have 3 tables
Personel, Excuse Log, Watch
Watch (watch they stand) (sdo, dd)
Excuse (its basically for people who are on leave, school, ect)
Watchs. (this one I am not to sure how to do.)
right now I have
I have input all the users in the personel table.
Which is great for right now, setup basic query for duty section, watchs they can stand.
What I wanted to do was have it autogenerate a watchbill for each duty section. So 4 sections requiring 5 people per day. Dont know how hard that is, or feasible by myself.
Subtracting Military Time
My new job requires me to use access so I'm learning as I go. :confused: I have already used previous threads from this forum to answer another problem I encountered. Thanks for providing this forum to the public!
I am attemping to run a query that will subtract military time. (I am not allowed to change the format of the times in the original tables. )
basically i want acalendar where you select your day and another calendar for the time. this should then automatically be put into next appoint ment label for the patient.
my situation is this:
i have a table "tblpatientdata" and a form "frmpatientdata" and on that form i want to put command button which takes you to a form which contains some sub forms that choose theday and time and then you click OK and it should update the next appointment section.
i dont knw how to do this and i do not want to make it too complex but could some one help me or give me a different easier idea....