Search results for query: *

Hi, I have 30 different queries, they each have a column called EER (this is the most important), then they have 2 other columns depending what query #. I checked the relationships window and made sure that the EER is joined from Query1 to all the other queries. What I am trying to do is...

Hi again, I have one more question about this. I need to have this statement done for 30 gages, the numbers in the code would change (GageID1 & ParameterMeasured1). Do I need to make 30 different queries or is there an easire way. In the end I want to just pull the EER# which is the same in...

Hi cmmrfrds, Thanks for the fast reply. I tried this: SELECT TestRev2.EER, ParameterMeasured1, [GageID] & " " & [GageDescription] AS Gage1 FROM TestRev2, Gage WHERE (((Gage.GageID)=[TestRev2].[GageID1])) ORDER BY TestRev2.EER; The only problem with it is that if the one GageID is...

Hi, When using the AS in SELECT to select two columns as 1 how do you put a space between the two? My code is: SELECT TestRev2.EER, TestRev2.ParameterMeasured1, [GageID] & [GageDescription] AS [Gage 1] FROM TestRev2, Gage WHERE (((Gage.GageID)=[TestRev2].[GageID1])) ORDER BY TestRev2.EER; It...

Hi again, Okay, I've got it down from displaying 129 fields to 25 but something still isn't right with my code. I have the TestRev2 table with EER as the primary key, the Gage table with GageID as primary, ParameterMeasured table with ParameterMeasured as primary key. When I run the query...

Hi GUJUm0deL, I e-mailed the zip file to you containing the three htm pages you need. I thought I'd let you know ahead of time so you can expect an e-mail with an attachment. (I didn't know if you were like me where I never open attachments from people I don't know). I hope this is the code...

Hi, The reason why the database is designed that way is because the client specifically wanted it. (Trust me, I wouldn't of done it this way if it was up to me). At first there wasn't even dropdowns for the Gages but I finally talked them into that (it's better than updating every field when...

Hi GUJUm0deL, Sorry about taking so long to get back to you, I've been really busy. Do you still want me to e-mail you the code? Jay Get The Exposure Your Web Site Deserves http://www.sewizard.com

Hi, I would like to use a If -> Then but I can't figure this out. I have 3 tables that I need to pull certain data from. Table 1 - GageID, GageDescription (GageID is used as a dropdown in Table 3) Table 2 - ParameterMeasured (used as dropdown in Table3) Table 3 - EER, GageID (there are 30...

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

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...

You have to put in in the body and it displays a : <form> <p><input type=&quot;button&quot; name=&quot;printWhole&quot; value=&quot;Print&quot; onClick=&quot;parent.print()&quot;></p> </form> If using frames you need to: ****Create 1 page w/ the frame that you will probably have the...

What do you mean by multiple rows and not multiple columns? I could send you the database if you want to see how I have it all set up. Thanks in advance! Jay Get The Exposure Your Web Site Deserves http://www.sewizard.com

Okay here's my problem, I have 1 database with 2 tables (well really 4 but only 2 of them need to be queried really) The first table is &quot;Gage&quot; with &quot;Gage ID&quot; as the primary key, also has a field &quot;Gage Description&quot; The 2nd table is &quot;Testrev2&quot; with...