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.

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

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

Back
Top