Prev: adding new columns
Next: Query SQL Syntax
From: tcek on 27 May 2010 18:03
I am creating a table with a "make table" query. I want to query by customer
number than by date of order. I want the customer number to be ascending
while the date of order to be descending. I can make the query perform the
desired functions but when the table is made the sort order is not like it
should be. I want the table to look just like the query. Any advice would
help.
From: PieterLinden via AccessMonster.com on 27 May 2010 18:22
tcek wrote:
>I am creating a table with a "make table" query. I want to query by customer
>number than by date of order. I want the customer number to be ascending
>while the date of order to be descending. I can make the query perform the
>desired functions but when the table is made the sort order is not like it
>should be. I want the table to look just like the query. Any advice would
>help.

Okay, I'll do my best John Vinson impersonation...

"Tables are UNORDERED collections of records." If you want the records
sorted a specific way, use a Query - that's what they're for.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1

From: KARL DEWEY on 27 May 2010 19:36
>>I want the table to look just like the query. Any advice would help.
Don't try!
Access stores data records like a barrel of bricks, jumbled.

Use a query or report to do your sorting.

--
Build a little, test a little.


"tcek" wrote:

> I am creating a table with a "make table" query. I want to query by customer
> number than by date of order. I want the customer number to be ascending
> while the date of order to be descending. I can make the query perform the
> desired functions but when the table is made the sort order is not like it
> should be. I want the table to look just like the query. Any advice would
> help.
 | 
Pages: 1
Prev: adding new columns
Next: Query SQL Syntax