By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Payroll / timecard

hyperpau
Expert 100+
P: 184
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.
Aug 15 '07 #1
Share this Question
Share on Google+
5 Replies


BradHodge
Expert 100+
P: 166
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.
Aug 15 '07 #2

hyperpau
Expert 100+
P: 184
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.
Aug 20 '07 #3

BradHodge
Expert 100+
P: 166
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.
Aug 20 '07 #4

hyperpau
Expert 100+
P: 184
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?
Aug 28 '07 #5

BradHodge
Expert 100+
P: 166
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.
Aug 28 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.