How to run a query

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

Guest

I have a query ParticipantReportQuery.

I would like this to be run when I open up a report. To display the
information in the report.
 
HI,

A nice quick way for you:

* View the query by clicking "Queries" in the left hand pane of the Access
database window.
* Select the query you want to use.
* With the query selected (not open), click the "Auto Report" icon on the
Database toolbar

You can then have some fun making the report look pretty, but all the data
from your query should be there.
Alternatively you can click the Report icon on the same toolbar which will
enable you to step through the process of creating the report.

HTH

Jamie
 
If the query is the report's recordsource, then it will run when you open
the report. Am I missing something?
 
I tried that and none of the data has showed up on the report.

I looked at the query and it is blank. I think that the query is not
pulling the information any suggestions?
 
When you run the query on its own does it pull the data?
If it doesn't, this would indicate the problem is with
your query.
 
I did what you said and none of the data is showing up. It has the variable
names which I think is just the label it creates for each of the field that I
want displayed but no data. Below is a sample of what I have in the query.
Could it have something to do with the relationship of the tables.

StudyTitle
Patient_Registry
Descending
checkmarked
 
Back
Top