>Bret,
>Thanks for your response. Yes, the alias name is in front of the field name, yes the alias matches the cursor name, and yes the cursor is selected before the report is run. Again -- if I preview, it's totally correct. It's only when I print that it seems to lose sight of which cursor its supposed to be using. Any additional thoughts would be welcome!
>Mary
You could try to run the program in debug mode and turn a watch on for what table is currently selected. Tell the debugger that you want to stop execution of the program if the currently selected table is changed. Go back to the app and send the report to the printer and see if the debugger senses that the selected table/your cursor has changed. That is the best I can do, good luck.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope