Query does not display fields in same order as SQL or Design View

[Guest]

I set-up a standard query with one simple right join using the query builder
tool in MS Access. When I run the query, the fields (note: I am talking
about the fields and NOT the field values) do not display on screen in the
same order that they are in in either the SQL or design views. I need to
have the fields in the order I specify

The SQL for this query is as follows:
SELECT screen_name_tbl.[Screen Name], modifications_tbl.[tab/field],
screen_name_tbl.[GNATS and CAPPS], modifications_tbl.Title,
modifications_tbl.[Requested Change] AS Problem,
modifications_tbl.requestor_tbl_ID AS Testor, modifications_tbl.severity_ID
AS Severity, modifications_tbl.status_tbl_ID AS Status,
modifications_tbl.Tech_Comments AS Remarks, modifications_tbl.[Remarks],
modifications_tbl.[Resolved On], modifications_tbl.IT_Remarks AS ['More
Details to Reproduce Defect'], modifications_tbl.[S No]
FROM screen_name_tbl RIGHT JOIN modifications_tbl ON
screen_name_tbl.ID=modifications_tbl.screen_name_ID
WHERE (((modifications_tbl.classification_tbl_ID)=16));

When I run the query, the fields display in the following order:
Title
Remarks
Screen Name
Tab/Field
GNATS/CAPS
Problem
.... etc.

Any ideas to get the results in the correct order?

 

[John Spencer]

This can happen if the columns have been dragged around in the datasheet
view. Access will store the new order.

The easiest way to fix this, is to copy the SQL into a new query and then
save the new query with the old query name. Safest is to rename the old
query first and then save the new query with the original old query name.