View Single Post
  #7 (permalink)  
Old March 30th, 2005, 05:28 PM
rgerald rgerald is offline
Friend of Wrox
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts

Try using brackets and not parentheses around the field names like this:

SELECT TOP 10 * FROM Product  WHERE ([ManufacturerFeaturedOrder] Is Not Null) AND ([ManufacturerID]=" & man & ") AND ([Active]=True) ORDER BY ManufacturerFeaturedOrder;
Reply With Quote