Major problem with queries - Two Tables in Access 2000

[jayphilips]

Hi,
I am trying to query one table called TestRev2 that reads some data from another table. What I need is to create a query that will match thefield in TestRev2 and return certain info.

TestRev2 table fields needed for querying:
EER, GageID1, ParameterMeasured1, GageID2, ParameterMeasured2, GageID3, ParameterMeasured3,...(this goes up to GageID30, ParameterMeasured30)

Gage table:
GageID, GageDescription (the GageID# in the TestRev2 table is a dropdown with the data coming from this table)

When I query the TestRev table I need it to return the GageDescription as well that matches the GageID

The SQL statement I created does return back the info I need, instead of returning 1 row that reads:

EER - GageID1- GageDescription1 - ParameterMeasured1 ....(Up to 30)

It returns:
EER-GageID1-GageDescription1-ParameterMeasured1-GageID2-GageDescription1-ParameterMEasured2 (and so on as one row)
EER-GageID1-GageDescription2-ParameterMeasured1-GageID2-GageDescription2-ParameterMeasured2 (and so on as another row)

My code is:

SELECT TestRev2.EER, TestRev2.GageID1, Gage.GageDescription, TestRev2.ParameterMeasured1, TestRev2.GageID2, Gage.GageDescription, TestRev2.ParameterMeasured2, TestRev2.GageID3, Gage.GageDescription, TestRev2.ParameterMeasured3, TestRev2.GageID4, Gage.GageDescription, TestRev2.ParameterMeasured4, TestRev2.GageID5, Gage.GageDescription, TestRev2.ParameterMeasured5, TestRev2.GageID6, Gage.GageDescription, TestRev2.ParameterMeasured6, TestRev2.GageID7, Gage.GageDescription, TestRev2.ParameterMeasured7, TestRev2.GageID8, Gage.GageDescription, TestRev2.ParameterMeasured8, TestRev2.GageID9, Gage.GageDescription, TestRev2.ParameterMeasured9, TestRev2.GageID10, Gage.GageDescription, TestRev2.ParameterMeasured10, TestRev2.GageID11, Gage.GageDescription, TestRev2.ParameterMeasured11, TestRev2.GageID12, Gage.GageDescription, TestRev2.ParameterMeasured12, TestRev2.GageID13, Gage.GageDescription, TestRev2.ParameterMeasured13, TestRev2.GageID14, Gage.GageDescription, TestRev2.ParameterMeasured14, TestRev2.GageID15, Gage.GageDescription, TestRev2.ParameterMeasured15, TestRev2.GageID16, Gage.GageDescription, TestRev2.ParameterMeasured16, TestRev2.GageID17, Gage.GageDescription, TestRev2.ParameterMeasured17, TestRev2.GageID18, Gage.GageDescription, TestRev2.ParameterMeasured18, TestRev2.GageID19, Gage.GageDescription, TestRev2.ParameterMeasured19, TestRev2.GageID20, Gage.GageDescription, TestRev2.ParameterMeasured20, TestRev2.GageID21, Gage.GageDescription, TestRev2.ParameterMeasured21, TestRev2.GageID22, Gage.GageDescription, TestRev2.ParameterMeasured22, TestRev2.GageID23, Gage.GageDescription, TestRev2.ParameterMeasured23, TestRev2.GageID24, Gage.GageDescription, TestRev2.ParameterMeasured24, TestRev2.GageID25, Gage.GageDescription, TestRev2.ParameterMeasured25, TestRev2.GageID26, Gage.GageDescription, TestRev2.ParameterMeasured26, TestRev2.GageID27, Gage.GageDescription, TestRev2.ParameterMeasured27, TestRev2.GageID28, Gage.GageDescription, TestRev2.ParameterMeasured28, TestRev2.GageID29, Gage.GageDescription, TestRev2.ParameterMeasured29, TestRev2.GageID30, Gage.GageDescription, TestRev2.ParameterMeasured30
FROM Gage INNER JOIN TestRev2 ON (Gage.GageID = TestRev2.GageID2) OR (Gage.GageID = TestRev2.GageID1) OR (Gage.GageID = TestRev2.GageID3) OR (Gage.GageID = TestRev2.GageID4) OR (Gage.GageID = TestRev2.GageID5) OR (Gage.GageID = TestRev2.GageID6) OR (Gage.GageID = TestRev2.GageID7) OR (Gage.GageID = TestRev2.GageID8) OR (Gage.GageID = TestRev2.GageID9) OR (Gage.GageID = TestRev2.GageID10) OR (Gage.GageID = TestRev2.GageID11) OR (Gage.GageID = TestRev2.GageID12) OR (Gage.GageID = TestRev2.GageID13) OR (Gage.GageID = TestRev2.GageID14) OR (Gage.GageID = TestRev2.GageID15) OR (Gage.GageID = TestRev2.GageID16) OR (Gage.GageID = TestRev2.GageID17) OR (Gage.GageID = TestRev2.GageID18) OR (Gage.GageID = TestRev2.GageID19) OR (Gage.GageID = TestRev2.GageID20) OR (Gage.GageID = TestRev2.GageID21) OR (Gage.GageID = TestRev2.GageID22) OR (Gage.GageID = TestRev2.GageID23) OR (Gage.GageID = TestRev2.GageID24) OR (Gage.GageID = TestRev2.GageID25) OR (Gage.GageID = TestRev2.GageID26) OR (Gage.GageID = TestRev2.GageID27) OR (Gage.GageID = TestRev2.GageID28) OR (Gage.GageID = TestRev2.GageID29) OR (Gage.GageID = TestRev2.GageID30);

Can someone please help me????

Thank you in advance!! Jay
Get The Exposure Your Web Site Deserves

http://www.sewizard.com

 

[WVZ]

Please see my question on SQL subquery using DLookup. I have solved the subquery problem based on another query.

The code is at the foot of my question

HTH

Werner

 

[jayphilips]

Hi again,

I looked at the SQL subquery using DLookup but now I'm even more confused...

Can you explain what you mean a little more? As you can tell I'm not real god with SQL

Thanks in advance!!
Jay
Get The Exposure Your Web Site Deserves

http://www.sewizard.com