Sorry, I haven't responded but I've been busy and have not been able to take
an extended period to examine your problem. At this point, I just don't
understand what you are attempting to do.

One thing that bothers me is you keep saying you are using a query (a select
statement) in the footer of the report. That makes no sense to me. You
cannot use a query in a footer and you can't use it as the source of a
control.

I will try to find some time this afternoon to look at your problem. In the
meantime, please copy and paste the SQL statement you are using as the
report's record source. And try to explain what you are attempting to
accomplish in the report's footer (not the page footer).

To make sense of this, I am probably going to have to print out all the
postings in this thread and then ask additional questions.


"chickalina" wrote in message
...
Is there anything anyone can do? I'm in desperate need of help.

"chickalina" wrote: