Order By in Query Spuriously Filled In

M

MIG

Recently, with Access 2003, I've often been getting a parameter
dialogue when I try to run a query I've just saved.

When I search for where on Earth the parameter name came from, it
turns out to have been saved as an Order By property that I certainly
never set.

I never use the Order By property in Access because, basically, it
doesn't work. I would always sort the query if the order mattered.

Does anyone know what's causing Access to fill in the Order By
property of a query with spurious fields in this way?
 
P

Phil Hunt

2 possiblity
1) You delete a column in the table on which the query is based. Access will
prompt you to find out
2) You click on the heading of a column and it will save the 'order by'
clause property. You can run the query and right click somewhere (i foget
where) and see the property. You can clear it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Web - Sorting Calendars by Alphabetical order? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
order number in query 2
Automatic Emails sent to my Contact Groups by Microsoft 1
Select query not being saved 5
Order by Clause Causes new record to go to top of query 1
Saving files in alphabetical order 1
Order by in rowsource 1

Top