Help with select query

[tl mike]

I am trying to setup a query where all the data related to one item is in line but all I get are sets of blank spaces and shows the main item three different rows with one item that is related to it one three different rows

So what I am trying to do is have a column for the part number, front, rear, side and for the part number all the related data will show in one row instead of one 3 different rows with one piece of data in each row.


tblPartNumber
qryFront
qryRear
qrySide

What I have now

PartNumber______Front______Rear_______Side
12345___________asdf
12345_____________________asdfs
12345______________________________asdfsaf

What I want

PartNumber________Front________Rear_____Side
12345____________asdf_________asdfs____asdsaf

 

[gemma-the-husky]

have one further query with the table and the 3 queries - link the partnumber to the partnumberid in the 3 queries with left joins (i think - all the partnumber table, and the queries where equal anyway)

then just drop the fields into the query.

 

[tl mike]

It worked when you mentioned it I couldnt believe I didnt think about it but also I am kind of burnt right now from all the work I have to do (cant wait till 5pm tonight fri!!!) So I can clear my mind for a few days

Thanks for your help!!