Search results

I got this one to work. Avg3M_6M_Rank: ([3MRank]+[6MRank])/2

Its just adding the two feilds together? or am I doing something wrong? 3M6MAvg: Avg([3MRank])+Avg([6MRank])

I’ve been searching the web and can’t find a straight answer. If I was to get an average of two fields in access how would I do it? I would think something like this Avg([3MRank]),([3MRank]) or Avg([3MRank]) and ([3MRank]) or =Avg([3MRank]) + ([3MRank]) Could someone please just show me...

Rating 1-5 with 1 being the best I have a table that has a total number of apps per rep. I would like to score my reps on a 1-5 scale. The formula I thought would work was 0to5: “[3MRank]/([Past_3_Month#]-1)*5” But this data went from 0.00000.24464 to 123.35544 Can someone help me find...

I'm trying to get I think it’s called a rolling scale. I have 500 records but I would like the rolling scale to rate them from 1-5 with 1 being the best. The formula I thought would work was "3Month_0to5Rank: [3MonthRank]/([Past_3_Month#]-1)*5" but turns out if keeps going after 5 or I tried...

Would someone please help me by checking my rank table in my database? Please let me know if you feel it setup properly and that the formulas work efficiently. Database Attached The one problem I’m having is that when the rank reaches its max number it just starts putting in the total...

something like this? Expr1: IIf([3MonthRank]="*5089*",0,[3MonthRank]) Would someone please take a look at my database and help me find a way to change the “5089” to just be the last number in my ranking. So in 3MonthRank all the “5089’s” should be 692 And in 6MonthRank all the “5089’s” should...

I jzwp22, and thank you for taking the time to help me with this issue. I’m still learning so I really appreciate the help with normalizing. Once I’m able to complete this report I’m going to go back and work on normalizing my database, is there a chance in the meantime we are able to make...

I’m working on setting up ranking table that should rank 3 months apps. 6 months apps and 12 month apps. The ranks should be laid out from 1-total number of records. For some reason it’s not do this. Could someone please take a look at the code below or the attached database and help me...

HTH, I have attached a sample databse. let me know if I can do anything else

Ok, I have a couple of quirky things going on with my database. The first is my Rank formula. For some reason I have to have two Rank fields in order for at lest one to be correct. **I have attached the sample database if you want to view that also** The second one is when I’m trying to...

What type of Query Should I use so My Data don’t Duplicate? Please Help! I'm wondering what would be the correct way to combined queries that have two columns that are different, but need to be added to the same report I’m trying to link four tables together. In one table I'm going to be...

I need to take four queries and make them into one table This is what I get when I just do a simple select query. SELECT Wholesale_Rank_qry_2.OMNI_Number, Wholesale_Rank_qry_2.branch, Wholesale_Rank_qry_2.branch_name, Wholesale_Rank_qry_2.[Rank>], Wholesale_Rank_qry_2.[0to5Rank]...

you were right again vbaInet, Just needed to change the > to < Thanks for the help

Thats the first thing I tried, not sure why that didnt work? Do you have any other ideas I could try?

I really appreciate you giving it a try vbaInet, but it’s still backwards. anything else I can try?

is there a way I can have it corrected in my query? Thats kind of what I'm needing

I’m trying to correct my ranking formula. I was using A, but after running the report with all the other criteria I notices it was backwards. I tried B and C, and still couldn’t get the Ranking correct. How would I change this from pulling 1-500 to 500-1 A Rank: (Select count(*) from...

Thanks again Bob, that worked perfect

Thanks Bob