Try this:
Open your report in design view. Click "View" then "Properties." Or, if you
prefer, in the far left corner, you should see a gray box (it may have a
black box in the middle of it. If it doesn't, it will when you click it) just
above the one ruler bar and next to the other. Double click the gray box and
this will also pull up the properties. Go to either the "Data" tab or "All"
tab. Look for "Record Source." Click your cursor into the white box there,
then click the box with the three dots that shows up to the right.
Up above, in the gray area, you'll see your table or query. Add any other
tables or queries you want by right clicking in the gray area, then clicking
"Show table." If you are needing to add a query, click the "Query" tab and it
will display your queries. Add any tables or queries you need to add. You can
then click and drag any of the fields for those tables or queries right down
into the white table looking area in order to add them to the query. I hope
this helps.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
