Search results for query: *

Sorry guys - I'm an idiot. PHV caught the error in his first post - it just made a whooshing sound as it went over my head... So sorry and thanks for hanging in there with me... Todd

No - notice the Length field? For each Length field, Table3 needs to have the information from Table1, and Table2. The trick is Table2 contains only some of the information from Table1 - it needs the rest. In short Table1 contains screw head parameters, and Table2 contains the lengths.

Sorry - I'm not explaining this well - for arguments sake, I need a 3rd table built containing all the records from Table2 combined with Table1 based on Dia. Hopefully I'm making sense...

PHV, They are there - I just shortened the tables - I didn't think anybody wanted to see the whole lot...

PHV, I did that, and I wound up with blanks, I as hoping to populate the blank fields: Sheet2.Dia C H L A D F T J Descr Length Sheet6.Dia #10-24 0.018 0.19 0.312 0.19 0.218 0.09 0.15625 #10-24x2.5 2.5 #10-24 #10-24 0.018 0.19 0.312 0.19 0.218 0.09 0.15625 #10-24x2.75 2.75 #10-24 #10-24 0.018...

Duane, Right - the Dia field is the common denominator, Table2 is actually much longer than Table1 because of the Length field. The Descr field is just a combination of Dia and Length. The Length field is hard coded of the screw length offerings. The Why is a bit more difficult - have to...

Can't seem to find what I'm looking for - I could easily have missed it or just plain not searched for the right thing - it's been a while since I used Access... I think I'm close, but I can't quite seem to get there - but I have two tables, one is basically a lookup table (Table1), the other...

Thanks Duane! That was the ticket - have a star!

Should have previewed this sorry... From this: ModelID ArmStyle CushionCount ComponentLoc GradeA GradeB GradeC GradeD GradeE CP C 1 A 0 27 52 79 104 To this: ModelID ArmStyle CushionCount ComponentLoc Grade Value CP C 1 A A 0 CP C 1 A B...

I have a table with the following fields: ModelID ArmStyle CushionCount ComponentLoc GradeA GradeB GradeC GradeD GradeE CP C 1 A 0 27 52 79 104 What I need to do is convert this to: ModelID ArmStyle CushionCount ComponentLoc Grade Value CP C 1 A A 0 CP C...

That did the trick - thanks to you and PHV, it's now working - thanks and have some stars!

Hi Duane, I'm too much of a newbie to understand the difference between "Dense" vs. "Standard" ranking - I'm sure you're right - I just have no idea what the "nuts and bolts" of that would be. FWIW, it's really in the reports for the announcer to read the results, the 1 1 3 4, really throws...

Hi PHV, That gave me some strange results when I ran it: School GymnastID Gymnast Event Score Rank 20 101 Gymnast1 Bars 8.50 40 22 102 Gymnast2 Bars 8.50 40 20 103 Gymnast3 Bars 8.45 44 18 151 Gymnast4 Bars 8.35 49 So I'm not sure that's it, but it did answer some of...

Hi Duane, I need 1 1 2 3, not 1 1 3 4... Hi TheAceMan1, I'll dig deeper into the link you provided and see if that one solves the problem for me... Thanks Guys!

...my query: SELECT quniAAScores.School, quniAAScores.GymnastID, quniAAScores.Gymnast, quniAAScores.Event, quniAAScores.Score, (SELECT 1+ Count(*) FROM quniAAScores AS S WHERE S.Score > quniAAScores.Score AND S.Event = quniAAScores.Event) AS Rank FROM quniAAScores WHERE...

Thanks Duane, that did it!

I have a sub form which displays as a data sheet and in the form footer, I have an unbound text box with the sum I need, and then on my main form, I have another unbound text box with it's source set to the text box on my sub form. Then I realized I need to sum the top 4 values - not all of...

Thanks MajP - I knew it was something I was doing...

Hi Irfcbabe, This probably won't be of much help, but I'm not sure VB is capable of collecting a list of running applications, the problem is the application class doesn't change, and neither does the path of the application. You'll need to look to the WindowsAPI to do what you need for that -...

Okay - I know I've done something stupid, I just can't figure out what... My Main form (DB Attached) has a couple of buttons on it to edit either the schools or view the scores results. When I press the "Edit Schools" button, and then return to the form Main, all seems well. If I close and...