Error encountered while using SELECT Top 10 statement

  • Thread starter Thread starter Khris
  • Start date Start date
K

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?
 
Hi,

Not in general. A statement SELECT TOP 10 would generally work without
problem. Just in case, have you installed the latest services releases for
your version?

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top