AlphaPress Publishing
P.O. Box 5942 Albany, NY 12205
Tel: 518-250-3890


Section Menu 

Are you a University or College bookstore and want to order multiple books?  Email us at or call us at 518-250-3890.  We will be happy to talk to you.  

Are you a professor and you need a sample copy?  We will be happy to send you a pdf or printed copy!  Email us at

Are you outside the United States?  We can ship multiple books worldwide in most countries.




Define the order of the parameter prompts in a parameter query

To contact the author click here

This article is from the book "Access 2007 Pure SQL

To download the sample database click here

To download the sample database click here


Define the order of the parameter prompts

Retrieve order information using orderdate, state, and ordertotal as parameters


Using multiple parameters might present a problem if we enter them directly in the query design grid in Access 2007.  In this case, Access will present the parameters from left to right according to the lineup of the columns in the grid.  Some sources suggest entering parameters in the "Parameters" sheet in the "Show/Hide" group of the "design" tab to force order.  It is really not necessary to type our parameters a second time.  In our SQL statement, we just type our parameters in the order we would like them to appear. 

However, always think about the logic behind the parameter lineup.  In this example with the AND operator, the order will not make a difference in the result set since all three parameter values will apply concurrently on the fields for which they are specified.  However, there might be cases in which we want a certain date range to be specified first and then, use operators to search for data within that range using operators different from AND. 

In this example, the parameters are: NY, 1/1/2009, and $200. 


SELECT OrderID, OrderDate, City, State

FROM Qry_Parameters_Base

WHERE ((((State)=[Enter State:]) AND (orderdate)>[Enter Date Later Than:]) AND (totalorder)>[Enter Amount Bigger Than:])