Please Help me to achieve this...

[shieriel]

Good Day. I am really not so good in access so please help me.
I have this database where i entered data per job order. Each job order has up to 10 operations and per operation has different kinds of machine used. The total Operations and total machine used are depending on every Job Orders.
My problem is how can i create a table (or maybe query/report) wherein i can show all of the Job orders per machine allocation. I attached thumbnail of my sample query. How can i make it that the column names are the actual Machine Names not machine1,mahine2,etc. and under the machine names should be the JO Numbers.

 

[John Big Booty]

Please refrain from double posting

 

[shieriel]

Please refrain from double posting

sorry...

 

[David Eagar]

It looks to me that your table structure is incorrect. You should have an Orders table, linked 1 to many with Operations table, linked one to one with Machines table

 

[shieriel]

It looks to me that your table structure is incorrect. You should have an Orders table, linked 1 to many with Operations table, linked one to one with Machines table

Sir could you please give me an example database for this? So i can have easy comparison for the needed structures and formats.
Thank you very much in advance...

 

[David Eagar]

I think it should look something like this (probably with some refinements)
As it happens, I spent the bulk of my working career in the printing industry, so I have a fair idea of what you are after.

ps, I object to being called Sir !!!

 

[shieriel]

I think it should look something like this (probably with some refinements)
As it happens, I spent the bulk of my working career in the printing industry, so I have a fair idea of what you are after.

ps, I object to being called Sir !!!

Sorry for that. Luckily, what i am really doing is for the small printing company! Thank you very much for the help. Let me check the attachment now...

 

[shieriel]

I think it should look something like this (probably with some refinements)
As it happens, I spent the bulk of my working career in the printing industry, so I have a fair idea of what you are after.

ps, I object to being called Sir !!!

Hi,
I am currently doing my database based on the database you gave to me yesterday. And it is now going good. But i have now another problem. I am required to create a monitoring per Product on my database which will be based on the database records from the last 3-month period.
I am now starting to think of this. When I enter a product name on the form, the database will give me information and possibly show me all the records from the last 3months of that specific product.
Is this possible?

 

[David Eagar]

Yes it is - what version of Access are you using?

New version with additional tables

 

[shieriel]

Yes it is - what version of Access are you using?

New version with additional tables

Hi again,
I am using access2003.