Quote Database Queries

[sales]

WE are currently using Microsoft R Access 97 and are
having a problem when we enter our customers sizes we put
the smallest tube size first and when we hit save and
reopen they are not in the same order that we entered .
Can anyone suggest how to correct this? Thank you.

 

[Kevin3NF]

Assuming you are using a form based on a table, you need to change the
recordsource to a query. In that query you should include a sort on
whatever field(s) you want. Access does not store records in any particualr
order, regardless of how you entered it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.