How to bring up a report for 1 record

P

pokdbz

I need to show a report with all of the information from the current day.
I have a couple tables that have a SSN and a number of questions with them.
So...
Table1 Table2
SSN SSN
Table1Date Table2Date
q1 q1
q2 q2

What I need to do is show all the question answers for the current date in
each table. So...
SSN
Table1 q1
q2

Table2 q1
q2
Is what I need displayed how do I accomplish this?
 
P

pokdbz

I need to have a button to do this. The SSN needed is on the current form
also as as text.
 
Top