I'm working on a project in Access 97. I'm fairly new to Access, and I
need to figure out how to display a Report based on data that a
secretary enters on a Form, The form looks like:
----------------------------------
Quote:
Search by: |
Amount Due: ______ to ______ |
.... ... ..... ..... |
----------------------------------
|
There are a few additional fields, but I have a Table with 7000 Names
of Residents and how much each person owes. The secretary would enter
the range in the 2 Text Boxes, and the report needs to bring back all
the Residents who owe an amount that falls between the range. I was
thinking of using DAO (limited to using Access 97) and place the data
into a Grid Data Control, but I was not sure how to send the
information from the Text Boxes to the Query.