Four highest values in a ROW

[KniteMare]

"I Hate ACCESS"

There that said.

I know how to get the top values in a column. But I need the top four by row.

To work it out I exported the query results to Excel, transposed them then imported as a new table back to Access. Then via a new query, I took the top 4 values by column from that.

Is there a way to get Access to return the values with out using Excel as I am doing?

I have 18 facilities I need to do this for and before I delve into Access and Code the whole thing I was wondering if I am going about this the wrong, or at least the less efficient way.

Yours in inACCESSable Frustration
KniteMare

 

[Joe4]

Without knowing all the details of your database, it sounds like the problem may be with how the data tables are designed. If tables are structured properly, you usually can do pretty much anything you want with Access.

You may want to reference an Access book or the internet and read up on putting the data in "Normal Form". These are a set of guidelines that if you follow, should allow you the flexibility to do what you want in Access.

Here is one link that talk about "normalization" and putting you data in 1st, 2nd, and 3rd normal form:

http://databases.about.com/library/glossary/bldef-normalization.htm