Error message encountered while using SELECT Top 10 statement in Access XP

[Khris]

I created a query selecting the Top 10 records in a table
with the highest cost. After creating the query and
viewing its results, I went back to the design view,
hoping to see the SQL statement. However, I encountered a
problem. A message box appeared. It said that MS Access
encountered some problems. What could have been the
possible reason for this? I think it has something to do
with my use of the SELEC TOP 10 statement because I
previously encountered this problem while I was exporting
the results of the same query to an Excel sheet. It seems
that the query gets corrupted once the results are
exported. Do you think that particular SQL statement is
not compatible with ACCESS?

 

[Bob Buckland ?:-\)]

Hi Khris,

You may want to also post this to the MS Access Queries
newsgroup,
news://msnews.microsoft.com/microsoft.public.access.queries


=========
I created a query selecting the Top 10 records in a table
with the highest cost. After creating the query and
viewing its results, I went back to the design view,
hoping to see the SQL statement. However, I encountered a
problem. A message box appeared. It said that MS Access
encountered some problems. What could have been the
possible reason for this? I think it has something to do
with my use of the SELEC TOP 10 statement because I
previously encountered this problem while I was exporting
the results of the same query to an Excel sheet. It seems
that the query gets corrupted once the results are
exported. Do you think that particular SQL statement is
not compatible with ACCESS? >>
--
I hope this helps you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

The Office 2003 System parts explained
http://microsoft.com/uk/office/preview/system.asp