Help badly needed...

[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 query 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]

From looking at your screen shot, I'm wondering if your table structure is properly normalised?

 

[shieriel]

From looking at your screen shot, I'm wondering if your table structure is properly normalised?

Sir that maybe is my problem here. I am not able to get the right structure because i cannot achieve the right result.

Could you please help me on how to solve this? Or maybe you may refer some sample database similar to what i am looking for?
Many many thanks in advance...

 

[John Big Booty]

Perhaps the tutorial will set you on the right path.

 

[shieriel]

thank you sir. I will try to look at the tutorial...

 

[vbaInet]

From looking at your screen shot, I'm wondering if your table structure is properly normalised?

I have a hunch I've mentioned this to shrierel before!

I am not able to get the right structure because i cannot achieve the right result.

It should be the other way round - you're not able to achieve the right result because you haven't got the right structure.

 

[John Big Booty]

I have a hunch I've mentioned this to shrierel before!

It should be the other way round - you're not able to achieve the right result because you haven't got the right structure.

I don't know why we bother sometimes the other thread seems to be going along swimmingly

 

[vbaInet]

I don't know why we bother sometimes the other thread seems to be going along swimmingly

Tell me about it. I wonder if they don't realise we can see all posts!