GolfingDuo
New member
- Local time
- Yesterday, 22:46
- Joined
- Apr 13, 2013
- Messages
- 6
So you are standing by the watercooler and I walk up, fill my waterbottle looking a little frazzled. You say "Hey you look like your on edge, what is going on?"
I take a long pull on my water and run my free hand through my gray hair. I shake my head and in a long sigh I say. "I need some help. I need to make a report that shows a work schedule for 10 employees. I need it to print in a monthyly calendar format with horizontal lines to show start and end date and time. I need it to show that there is or is not any overlap for that machine."
It has been a while since I have created a DB and I get some of this okay. So far I think I need three tables. One is the machines. Two is the product schedule (how long it takes to produce X number of products). The last would be work orders and that pretty much covers the data.
I think most of the data can be maniputated by queries and that is even done on the report. The report as we all know is the reason for a database. If it was just about the data it would be simpler to do a spreadsheet. It could get fancy and make a pivot table. That output can be a calendar of sorts.
Well anyway I have to go back to creating my tables and my desk. Thanks to anyone who might have an answer.
I take a long pull on my water and run my free hand through my gray hair. I shake my head and in a long sigh I say. "I need some help. I need to make a report that shows a work schedule for 10 employees. I need it to print in a monthyly calendar format with horizontal lines to show start and end date and time. I need it to show that there is or is not any overlap for that machine."
It has been a while since I have created a DB and I get some of this okay. So far I think I need three tables. One is the machines. Two is the product schedule (how long it takes to produce X number of products). The last would be work orders and that pretty much covers the data.
I think most of the data can be maniputated by queries and that is even done on the report. The report as we all know is the reason for a database. If it was just about the data it would be simpler to do a spreadsheet. It could get fancy and make a pivot table. That output can be a calendar of sorts.
Well anyway I have to go back to creating my tables and my desk. Thanks to anyone who might have an answer.
That is sad! I thought it was a great watercooler thread! 
. Maybe I should have :banghead: on the original post? 
