"Make table" query missing records returned by simple query - why?

  • Thread starter Thread starter Paul Danaher
  • Start date Start date
P

Paul Danaher

I have an invoices database, which has fewer than 780 entries, and I tried
to run two queries. The first is a "make table", with SQL

SELECT [invoices w@w].InvoiceNumber, [invoices w@w].[customer name],
[invoices w@w].[date paid], [invoices w@w].currency, [invoices w@w].[net
amount] INTO [invoices paid in 2003]
FROM [invoices w@w]
WHERE (((Year([date paid]))=2003))
ORDER BY [invoices w@w].[date paid];

but the output stops dead at 65 records, which is the end of September. A
simple query with SQL

SELECT [invoices w@w].InvoiceNumber, [invoices w@w].[customer name],
[invoices w@w].[date paid], [invoices w@w].currency, [invoices w@w].[net
amount]
FROM [invoices w@w]
WHERE (((Year([date paid]))=2003))
ORDER BY [invoices w@w].[date paid];

yields all 89 records.

How is this possible?
What do I have to do in a very simple accounting application to make sure
the SQL works properly?
 
Go to support.microsoft.com, and check that you have the latest service pack
for your version of Office, and also for JET.

If that does not solve the problem, and these are local Access tables (not
MSDE or ODBC), create a new (blank) database, import just the table and the
two queries, zip it down (e.g. WinZip), and I will look at it if you wish to
email it to the address below (replacing "at" and "dot" with the
characters). Include a copy of this thread please.
 
Back
Top