Hello everyone,
I'm trying to work out a problem I'm having with a report I've constructed to match our company's formatting. Before I move onto the report, let me explain how I've set up the tables and queries.
Tables: I currently have 3 tables. An Employees Table, a Project Table and a Time Worked Table. The tables are normalized to 3NL. I have Employee names and ID numbers in the Employees table (ID's are primary keys), JobID Numbers in the Project table (Primary key), and the Time Worked Table has foreign keys tied to both, and hold all the other data including job specifics, hours worked, employee names and ID's and total hours.
Queries: I have two queries, one that queries data form the Employee's table and one that queries data from the Time Worked table. The form I use is RecordSourcing the Time Worked table.
Now, with that said, heres my dilemma. If you take a look at my excel attachment, you'll see the format to which I must mold this report. I have very limited experience in Access, so setting up code/expressions to do what is asked of me is getting much too frustrating! Please read on.
Firstly, the report is centered around the Employee. Through my query, I was able to get Access to pull employees off the list in ABC order one at a time. This was a big step for me, since my last attempt at this database was completely worthless. If you look at the period ending, that is actually two dates: [Beginning Date] and [Ending Date] since this report has to prepare data for the pay period. I've set up the aesthetics of the report without a problem, including the expressions which put all the header dates in the right places. My goal for this report: to show a particular employee name/number and from that fill out his days worked on a particular job, descending numerically and placing his hours undernearth the appropriate date for the appropriate job number. It really seems simple enough but I'm completely road-blocked.
I hope the information I've provided is useful PLEASE don't hesitate to criticize my layout or offer better means to my desired end. As I've said in other posts, I'm a total noob at this and only have about 1 more week left on my internship to see the database completed. Thanks so much guys! You rock :rockon:
Please see my rapidshare.com download for the excel doc:
http://rapidshare.com/files/47937712/TIMESHEETS-Edit.xls.html
I'm trying to work out a problem I'm having with a report I've constructed to match our company's formatting. Before I move onto the report, let me explain how I've set up the tables and queries.
Tables: I currently have 3 tables. An Employees Table, a Project Table and a Time Worked Table. The tables are normalized to 3NL. I have Employee names and ID numbers in the Employees table (ID's are primary keys), JobID Numbers in the Project table (Primary key), and the Time Worked Table has foreign keys tied to both, and hold all the other data including job specifics, hours worked, employee names and ID's and total hours.
Queries: I have two queries, one that queries data form the Employee's table and one that queries data from the Time Worked table. The form I use is RecordSourcing the Time Worked table.
Now, with that said, heres my dilemma. If you take a look at my excel attachment, you'll see the format to which I must mold this report. I have very limited experience in Access, so setting up code/expressions to do what is asked of me is getting much too frustrating! Please read on.
Firstly, the report is centered around the Employee. Through my query, I was able to get Access to pull employees off the list in ABC order one at a time. This was a big step for me, since my last attempt at this database was completely worthless. If you look at the period ending, that is actually two dates: [Beginning Date] and [Ending Date] since this report has to prepare data for the pay period. I've set up the aesthetics of the report without a problem, including the expressions which put all the header dates in the right places. My goal for this report: to show a particular employee name/number and from that fill out his days worked on a particular job, descending numerically and placing his hours undernearth the appropriate date for the appropriate job number. It really seems simple enough but I'm completely road-blocked.
I hope the information I've provided is useful PLEASE don't hesitate to criticize my layout or offer better means to my desired end. As I've said in other posts, I'm a total noob at this and only have about 1 more week left on my internship to see the database completed. Thanks so much guys! You rock :rockon:
Please see my rapidshare.com download for the excel doc:
http://rapidshare.com/files/47937712/TIMESHEETS-Edit.xls.html