Search results for query: *

Good to go - thanks skip - I'll give it a go.

Okay - almost there. The column counts are off in my "sample". LocID = Column 1 Primary Y/N = Column 8 Business Unit = Colum 2 Sorry about confusing things.

There is only one Y per LocID

Hi Skip - LocID Primary Y/N Business Unit ABC1 Y GOV ABC1 N USMC FOR6 Y USN FOR8 Y USAF FOR10 N USAF FOR10 Y USMC The data is sequencial by LocID - I need to match the LocID, then Y, and...

Hello All - The following formula works but it does not work perfectly: INDEX(GMSL!$W$2:$W$5000,MATCH(A4,IF(GMSL!$H$2:$H$5000="Y",GMSL!$A$2:$A$5000,"Blank"),0)) However, instead of returning "Blank" if the data row is null or not a match, it returns 0. Even if I remove "Blank" is still get...

That did the trick - thanks Blue Dragon for the solution.

The breakdown should be based on age then score; ie. if over 46 years then criteria one, if between 40 - 45 yrs then criteria two and so on.

All - I am attmepting to sort out a nested formula that will display only one result - i.e. 1st, 2nd, 3rd, Fail. "D2" referes to age while "P2" refers to the raw score of my event. When I run the follwing formula I get something like "FalseFalseFalse1"; when I only want the "1" to be...

MajP - It all works now - I was being "thick". Thanks so much for your expert help - here's a star and a Commedation. Regards, S/F Killer23

Alright - finally getting somewhere here. Thanks to MajP I have the Body Fat working in a query. Now I am stuck when I try to get my query to work within a form - PFT_History. The idea is that a clerk will fill in the required "raw" data (i.e. # of pull-ups, crunches, etc ...) and the query...

I'm feeling very much like a "rock" here. Perhaps I'm missing something very basic. Do "Public Function" codes go into "Modules" or somewhere else to run. I've tried each sample offered and can create modules, place that module into the appropriate "Control Source" on my form and get - -...

I'm code agnostic - meaning, I don't know how to code - thus I've come here to ask the experts. I concur that code would seem to be much more efficient for both issues rather than a lookup. The extent of my coding knowledge if very (VERY) basic IIf statements. I will try the public log...

MajP - For body fat I would prefer to utilize the formula - it works perfectly in excel, but access seems to choke on Log10 functions; or, perhaps, it's my lack of skill within access is what's choking it. Still no luck with your last solution however. By chance have already created such a...

MajP What shows in the control source of my unbound text is: =PFTClass([<<intAge>>],[<<intScore>>]) Both Age and Score are formatted as general numbers. Score is a field bound as such - =(Run_Score]+(P/U Score]+[Crunch_Score]) - if that has any bearing in the issues at hand. S/F Killer23

MajP Reserve Side Phoenix - 6th Engineer Support - Bulk Fuel Co C - 1st Platoon Commander Civ Side State of Az - Tech Service / Web Manager S/F Killer23

MajP - I tried your solution - pasted the code into a module - saved as PFT class. When I bind this to the "Class" unbound text box the result is #Named. Any suggestions? S/F, Killer23 (GySgt)

I've never done a table lookup - although I have a table for my second problem - that looks something like this: Circ_Value 60 60_5 61 61_5 62 62_5 13 13.5 9 9 14 10 11 10 11 14.5 11 12 11 12 10 9 15 12 13 12 12 11 10 15.5...

I tried to - incorrectly - modifiy the code above. I did not need the Gender portion (made a mistake in that assumption). I need the PFT_Score to upated the Class field accordingly: Private Sub PFT_Score_AfterUpdate() Dim Age As Integer Dim PFT_Score As Integer GetClass.Value = PFT_Score...

Thanks JoeAtWork - I'll give it a shot and let you know what my results are.

The calculations are on the form itself; how would I use a table etc . . .?