Query Designer

[kriemer]

The attached jpg shows a view of Access Query Designer that I can not seem to duplicate. I am trying to use the Access GUI to build ranking queries but it appears that I first need to get into this view before I can do so. I am using Access 2k3 SP3 so it can't be a function of the version of software I am using (or can it?).

I hope that I am clear/cogent in my question, if not I apologize in advance.

Regards

k

 

[georgedwilkinson]

That view is for SQL Server based projects only. It is available when you create an "adp" project in Access.

 

[kriemer]

What I am looking for is a similarly GUI mechanism for Ranking Queries. Is there any such thing?

Thanks for taking the time to respond.

k

 

[georgedwilkinson]

The QBE is a GUI thing and it has easy to use buttons for ranking queries. How are your users running queries now? Are these queries bound to forms/reports/controls? If not, and you don't want users using the easy to use Access tools, then you must write code in your form/report/control to do whatever it is you want to accomplish.

 

[kriemer]

Am I alone in thinking that ranking is way too complicated in Access? I have been trying and trying with no success. Due to my lack of skill I am currently forced to export data to Excel and reimport ranked results to Access. Now the size of my database has grown to the point where Excel can no longer manage this function and so I am forced to move to what has always been my preferred solution; doing all the work in Access.

If anyone can take a look at the attached file and provide some comment on how to generate a ranking query based on the following:

Query: 1 long score
Group by: Date/Time, then EquationType
Rank by: PositionScore

Any help/guidance/comments would be greatly appreciated.

Thanks in advance

K