query reports

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

Guest

I have multiple reports "Scope Report" "THA Report"
I want to run a query to return the fields "Name" and "Date" in each of
these reports for each entry in the reports. CAn this be done and how do I go
about doing this?

Thank you for your help.
Russ
 
You can query tables and other queries. Attempting to pull data from reports
isn't a good thing. You can place existing reports on a main report as
subreports.
 
Thank you for your reply. My problem is I use the sql builder in teh report
so it is not running off a query per se. Is there a good way to get the list
of people in the report into a table that I can then put into master form.
When I pull up the master form in my database, I want to see whether or not
the particular person's form I am viewing is in the reports and if so which
report they are in so I can click and view the report from the master form
with out opening the report and scrolling through to find them.

Russ
 
I don't have a clue what your base requirement is for this. Your posting
seems to suggest you think records are stored in forms and reports. They are
not.

You should be able to use SQL statements similar to those used as the Row
Sources of your reports to pull required records.
 
Back
Top