Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored 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

Personel
SSN (Last4)
Last Name
First Name
Rate/Rank
Duty Section
Watch (watch they stand) (sdo, dd)

Excuse (its basically for people who are on leave, school, ect)
SSN
LastName
Watch
StartDate
Enddate

Watchs. (this one I am not to sure how to do.)
right now I have
StartDate
Starttime
SDO_Personel
DD_Personel


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.

I hope I explained it as best as I could.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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. )

Example:

Column A Column B
1111 6.5

I need 1111 - 6.5 in Column C

View Replies !   View Related
I Need To Create An Appointment Creator?
hi

i need to create and appointment creater.

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....

thanx

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved