maketable not working as expected

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

Guest

Hi,

I was trying to use a maketable query to produce a sorted list in a
temporary table the query follows:

SELECT [local mailing table].* INTO temp
FROM [local mailing table]
ORDER BY [local mailing table].[last name], [local mailing table].[first
name], [local mailing table].[middle initial];

The resulting file appears to be sorted but in chunks, that is last names
a...f appear then w... then back to b.. and so forth. Its as if the sort is
aborting when it is almost but not quite done.

Any work arounds?

Thanks,
Kim
 
pookie bear said:
Hi,

I was trying to use a maketable query to produce a sorted list in a
temporary table the query follows:

SELECT [local mailing table].* INTO temp
FROM [local mailing table]
ORDER BY [local mailing table].[last name], [local mailing table].[first
name], [local mailing table].[middle initial];

The resulting file appears to be sorted but in chunks, that is last names
a...f appear then w... then back to b.. and so forth. Its as if the sort is
aborting when it is almost but not quite done.
Click to expand...

Tables have no order. If you want order use a query.
 
Back
Top