dbTalk Databases Forums  

Access: Send Data to a Query from a Form

comp.databases comp.databases


Discuss Access: Send Data to a Query from a Form in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Wyrzykowski
 
Posts: n/a

Default Access: Send Data to a Query from a Form - 07-16-2004 , 09:50 PM






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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.