maketable not working as expected

[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

 

[Rick Brandt]

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.

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