View Single Post
  #5 (permalink)  
Old February 11th, 2004, 05:01 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
Default

Yeah, I got that working. But why does Access 2002 insist on inserting the TOP 100 Percent thing for select all queries? And how does this work?

For example, it turns this

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

Into this

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

I appreciate your help!
Reply With Quote