View Single Post
  #3 (permalink)  
Old February 11th, 2004, 02:57 PM
Justine Justine is offline
Authorized User
Join Date: Jan 2004
Location: Frederick, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts

Alright, I spoke too soon. Now I'm having the same problem with another query. Access 2002 insists upon inserting the TOP 100 PERCENT thing and I can't figure out why. This time I just want to select all fields in a table. But it gives me the error mentioned above and inserts the TOP 100 PERCENT.

SELECT TOP 100 PERCENT Web_Code08.tbl_Reports.*
FROM Web_Code08.tbl_Reports
WHERE (FY = 2004)
ORDER BY Order_Number

Thanks in advance...
Reply With Quote