Issue with sorting alphabetically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am actually not sure if this can even be fixed or not, but hopefully you
guys will have some ideas.

Access setup: several tables, 2 queries, handful of reports, no
forms/pages/macros/modules (2000 file format)

This database is used as an online help type of thing where the admin can
log new help requests. There are buttons that you can press to show pop ups
that allow you to select a topic/solution. Now, I was not here when they set
up this system, but I have been told that the database (specifically tables)
is somehow linked to this site (i.e. the pop up is dynamic; options in pop up
relate to the information in the tables).

The problem is that the admin has been going through some of the solutions
and changing what they were called. This has altered the way that they are
displayed in the pop up and caused them to no longer be sorted alphabetically.

My question is: is there a way to change the database so that the pop up is
sorted alphabetically?

Kelly
 
I add a column to my tables called "SortOrder". Then the query that feeds the
dropdown (or whatever control I'd need) uses SortOrderto sort on. I can
change the absolute position of ANY line-item by simply changing that number.
Something to think about anyway...
 
That could work, but if the database is being changed daily wouldn't I have
have to go in and change the values of SortOrder manually?
 
Yes. I was thinking about a more static set of popup data. You'd have to show
me the query that underlies that popup, so I/we could take a look at how to
possibly modify it to sort alpha by the correct field.
 
I am not entirely sure if the queries are used in the popups. I think they
are only used in the reports. I took a look at the html of the site, and it
seems to be accessing the database directly:

<A tabindex=""
href="javascript:selectsolution('sys_solution_id','sys_solutiondesc');">
and
<A
href="javascript:window.opener.effect_solution('','','sys_solution_id','sys_solutiondesc');self.close()">

with sys_solution_id and sys_solutiondesc being elements of the tables. I
could be wrong as I am not entirely familiar with how access interacts with
other things.
 
Okay, so I posted this question on another forum and got a response that said
I should modify the SQL string in the web browser. Would that be changing the
ORDER BY in the SQL view of the query?
 
I edited the SQL statment of the query, and it still isn't sorting the
solutions alphabetically. Below is my SQL statment, I want it sorted by
sys_solution_id.

SELECT request.sys_requestdate, request.sys_eusername, request.sys_ownedby,
request.sys_problemdesc, request.sys_request_timespent,
request.sys_requesttype_id, request.sys_solution_id, request.sys_solutiondesc
FROM request
GROUP BY request.sys_requestdate, request.sys_eusername,
request.sys_ownedby, request.sys_problemdesc, request.sys_request_timespent,
request.sys_requesttype_id, request.sys_solution_id, request.sys_solutiondesc
HAVING (((request.sys_requestdate) Between [Enter the beginning date] And
[Enter the ending date]))
ORDER BY request.sys_solution_id;
 
Back
Top