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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Paul Danaher" <(E-Mail Removed)> wrote in message
news:MqBFb.29850$(E-Mail Removed)...
> 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?