>Hi Grigore:
>
>My situation was simpler than what you described because my reports are all based on single tables only. Also, the other reports are set up identically and they have no problems at all.
>
>Having said that, I tried selecting the table first as you suggested and it made the problem report work. I don't understand what's happening but I'm glad it's fixed.
>
>Thanks for your help.
>
>Andrew

Andrew,

Just for the record... this sometimes happens if the report is called from a form with a grid on it, the grid can re-select it's recordsource before the report gets going so the report ends up working from the wrong table. One of the solutions is as Grigore suggested above.