Software

Ask something
Discussion Locked

MS ACCESS Ranking 0-5

0 helpful
1 reply

by mikevla

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Thank you for taking the time to read/help me with this query question.

I have a list of data that goes back 9 months. What I?m looking to do is put them in a grouping such as ?3 Months? 6 Months? and ?9 Months? and maybe a total of all with its not to hard to do. Then once that is done I would like to Rank then either by the past 3 months or even back 1 year.

The formula in excel looks like this =5-(AJ3/MAX($AJ$3:$AJ$10000)*5)

Thank you once again for your time and help

1 reply

by tony hopkinson

sqlwise
look up DatePart, DateDiff, DateAdd, and how to do group by.

select * From MyTable Where MyDate > DateAdd(GetDate(),month,-3)
for instance.

There's a lot of ways to skin this cat depending on waht you want but they all use the basic functions.

This discussion is closed to new replies.