MS Access Query with parameter

It's very common that you might need to query particular record instead of all of them. Therefore, parameter will be used in query . Let's create a customer outstanding order...

1.Create a query called "Outstanding order for specific cust" In this query, we use inner join for the tables involved. They are joined by linking secondary key  "sdan8" of sales detail table to primary key "aban8" of address book table. 

2. In the query design, we put in "Like [cust] & "*" "into customer field ABALP. "Between [startdate] and [Enddate]" into field POdate SDTRDJ and Outstanding code into Sale status field . Therefore, the query will prompt for customer name and startdate / enddate for those sale records which are in Outstanding status.

3. After this query is done, just run report wizard to embed it.