Create the cursor from wherever you call the report. Say for example you have a myreportbutton on a form for running this report, you might have something like this in the .Click:
SELECT .......... INTO CURSOR cMyReport
REPORT FORM PREVIEW
You would reference fields from cMyReport in your report.
>Thanks for the quick reply to my problem. I don't know how to place SQL in my properties, but, I will try dragging the relationship from the child to the master in the data environment. Thank you so much! (PS Where would I look to learn how to create the SQL and WHERE to put it) I do know how to view, cut, and paste SQL that has been generated, but have no clue how to use it in the properties.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.