Payroll / timecard

hyperpau

CAn anybody give me an advise on the best way to create a payroll or timecard ms access database?

This database should be on a recurring basis, meaning, it talks about all the days in a year.

I can't think of the best way to do this since i am imagining a table with a lot of columns representing the days of each month, which I am sure is not advisable.

BradHodge

I guess I don't understand why you would need a table with the days of the months in it. Are you thinking that you would have say the 1st of September and 35 people worked on that day?

Brad.

hyperpau

Quote:

Originally Posted by BradHodge

I guess I don't understand why you would need a table with the days of the months in it. Are you thinking that you would have say the 1st of September and 35 people worked on that day?

Brad.

this is for checking attendance on a daily basis as a basis of how much a trainee would get paid.

BradHodge

My apologies if I'm going off in the wrong direction, but...

What if you just had your Trainees table and then a form with a multiselect list box on it that showed all the trainees. You could choose all the trainees that were present that day, and use a SQL statement to append them to the payroll table?

Just a thought.

hyperpau

Quote:

Originally Posted by BradHodge

My apologies if I'm going off in the wrong direction, but...

What if you just had your Trainees table and then a form with a multiselect list box on it that showed all the trainees. You could choose all the trainees that were present that day, and use a SQL statement to append them to the payroll table?

Just a thought.

i'm looking into that idea. thanks
it's just that I have never worked with list boxes before. :(
is it easy to study?

BradHodge

No problem. I've not used them much b/c I usually use combo boxes. Here is a link that has some good info in it for you though List Boxes. Rabbit also has a good article on using multiple combo/list boxes to feed one another Cascading Combo/List Boxes.

Hope this helps,
Brad.

Payroll / timecard

re: Payroll / timecard

re: Payroll / timecard

re: Payroll / timecard

re: Payroll / timecard

re: Payroll / timecard

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about