Like a Cross tab Query out put required IN Query

[Christykvlklm]

I have compiled some data from different table. Now I need the data as per attached.

Welder | WelderName | PR01|PR02|PR03| UP TO PR10| having columns.

Data..W000 | XXXXXXX|Acc|Acc| up to Column 10. Last result should show.

If anyone can help us to resolve.

Thanks

Christy

 

[sneuberg]

I see two way of doing this. First is to create ten queries. The first would have PRO1, the second PRO2, etc. Then create a union query of these ten queries. You could then use the union query in a make table query.

The other way would be to write VBA code to open a recordset of the existing table and have the code do INSERT INTOs for each of the PROs for all of the records.

 

[plog]

Using the sample data you posted in the .pdf can you show exactly what the results should be? Include column names.

I think you could do this via a crosstab query.

 

[Christykvlklm]

Using the sample data you posted in the .pdf can you show exactly what the results should be? Include column names.

I think you could do this via a crosstab query.

How the out put required I attached in pdf file. page2

Result from RTResult from master table (page1 in pdf)

 

[Christykvlklm]

I made 10 query PR01, PR02, UP TO PR10. Then wrote Union Query. Then out put is if master table record is 50, union out put showing 500 records.

I need out put if master is 50 then the value for PR01 up to PR10 Should display against each record of 50. (Column header PR01 UP RO PR10) refer attachment in post (page2)

 

[Christykvlklm]

Using the sample data you posted in the .pdf can you show exactly what the results should be? Include column names.

I think you could do this via a crosstab query.

I made 10 query PR01, PR02, UP TO PR10. Then wrote Union Query. Then out put is if master table record is 50, union out put showing 500 records.

I need out put if master is 50 then the value for PR01 up to PR10 Should display against each record of 50. (Column header PR01 UP RO PR10) refer attachment in post (page2)

 

[JHB]

What if some is "Rej" like in the 3. record from the bottom, when should that be shown, could you clarify the criterias?
Could you post some sample data in a database or Excel sheet, (zip it then you haven't post 10 post yet).

 

[Christykvlklm]

What if some is "Rej" like in the 3. record from the bottom, when should that be shown, could you clarify the criterias?
Could you post some sample data in a database or Excel sheet, (zip it then you haven't post 10 post yet).

I uploaded the table. One record First result may "Rej" then again it will get "Acc". So the last result should show based on the RT Report date.

Thanks

Christy

 

[JHB]

Below is some of the data you uploaded, how can you say which one of the rejected is later get accepted, where/what is the link/key?

 

[Christykvlklm]

Below is some of the data you uploaded, how can you say which one of the rejected is later get accepted, where/what is the link/key?

First - 005 Rej
Second - 5R1 Rej
Third - 5R2 Blank (Waiting for Result) - Last Result should Show "Rej"
In this key is 3rd and 4th Column
But my option is to create new key with WelderNo & PRNo and Search for Last Result.