In access, how do I create a report that asks for amounts from the user and displays the items between those #

Question

I created a report from a table. It is a simple table that was made up to represent an inventory system. I have created a report following the directions of the assignment, but the last thing it asks for is to make the report of all items whose list price is between two amount entered by the user at the time the report is run. Please help me

Answer 1

Try make a paramertized query then base your report on the query rather than the table.

A parameterized query is made in the Query design view by adding the following to the creiteria in a column >[Greater] if you want an and function between two or more creiteria than you have to duplicate the column by adding it to the query again.

Below I have a table called T_34627779 and I extracting three columns of data and creating a paramertized query by
adding a WHERE clause.

Access will create these text based SQL commands and these may be entered or viewed by clicking on view SQL from within the query designer

SELECT T_34627779.RecID, T_34627779.Symbol, T_34627779.Price, T_34627779.Price
FROM T_34627779
WHERE (((T_34627779.Price)>[Greater than]) AND ((T_34627779.Price)<[Less than]));