Query/Parameter Question!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My table has the following fields- EmployeeID, RqstDate, FollowupDate, and
Rush(Yes/No)

My users would like me to create a form that they would be able to enter the
following information to filter the Records in the form. information as
follows
Select Employee ---[EmployeeID]
between RqstDate 1 and RqstDate 2 ----- [RqstDate]
between FollowupDate 1 and FollowupDate 2 ---- [FollowupDate]
Is it a Rush(Yes/No) ---[Rush]


So I thought of creating an unbound form that has unbound fields that has a
button that says Filter Information, so that the form will contain the
information that is filtered as per the requirements above.......

How do I do this????
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bound a DLookUp Value 2
Conditional Control Source Selection 2
Launching a Form from Within a Form to Create a New Record 1
Please help: Send object when argument satisfies 1
Using SQL code with VBA event coding 1
Excel Dates imported inconsistently 2
dcount problem 3
=DateAdd() Function 5

Back
Top