In my table each row has a QuantityOrdered column, a Product column, Option01-Option10 and other fields. My query is for a report in microsoft access, if that also helps.

You can’t upsize Access tables that contain dates earlier than January 1, 1953. Use saved queries as opposed to SQL statements as the data sources for Access objects.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

This paper proposes a method SQL detection and algorithm to detect and prevent the tautology and union query based attacks at run time. To demonstrate efficiency of this method dataset is taken ...