How to bring up a report for 1 record

G

Guest

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?
 
G

Guest

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

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

Query based on a parameter query, using VBA how do I to set the parameters 1
Setting a recordset for a report 1
Excel base year add up escalation problem.... 1
Reports are only totaling the fields for the first record 2
Searching a recordset to find the first record with a NULL value in acertain field 7
Excel VBA, Loop, array, cut and paste 1
Can you have a combo box choice run a report 1
Missing records when they're there 2

Top