G
Guest
I've got a report that I'm working on that groups on 5 fields. Four of those
fields have a footer section with calculations (sums and a couple
percentages). Now, when I try to run the report, I get a msgbox popping up
that says "No Current Record." I click OK and another pops up. This repeats
infinitely and I have to use Task Manager to kill Access.
Here's the interesting thing. If I remove one of the text fields, the
report works fine. If I put it back, it breaks. It doesn't seem to matter
which text field I remove, or which section I remove it from. Getting rid of
a text field makes it work. Adding another text field, whether it is the
same one I removed or a completely different one, breaks it again.
I found an article in the KB that I think is related to this:
http://support.microsoft.com/kb/888635/en-us
This is what they give for the workaround:
WORKAROUND
To work around this problem, use one of the following methods:
•Change the Group On group property to Interval for one of the field groups.
•Change the Group Footer group property to No for one of the field groups.
•Remove the calculations from the group footer.
Are they kidding? Is this the problem I'm hitting? Has this really been
around since 2004? I haven't had to work with Access for a couple of years
until now, but now I'm wondering how I'm supposed to create the report that
the client wants, if I can't group on the fields they want and give them the
calculations they want.
How have people been working around this? Why hasn't Microsoft fixed this
yet? It seems like a pretty major bug to me.
fields have a footer section with calculations (sums and a couple
percentages). Now, when I try to run the report, I get a msgbox popping up
that says "No Current Record." I click OK and another pops up. This repeats
infinitely and I have to use Task Manager to kill Access.
Here's the interesting thing. If I remove one of the text fields, the
report works fine. If I put it back, it breaks. It doesn't seem to matter
which text field I remove, or which section I remove it from. Getting rid of
a text field makes it work. Adding another text field, whether it is the
same one I removed or a completely different one, breaks it again.
I found an article in the KB that I think is related to this:
http://support.microsoft.com/kb/888635/en-us
This is what they give for the workaround:
WORKAROUND
To work around this problem, use one of the following methods:
•Change the Group On group property to Interval for one of the field groups.
•Change the Group Footer group property to No for one of the field groups.
•Remove the calculations from the group footer.
Are they kidding? Is this the problem I'm hitting? Has this really been
around since 2004? I haven't had to work with Access for a couple of years
until now, but now I'm wondering how I'm supposed to create the report that
the client wants, if I can't group on the fields they want and give them the
calculations they want.
How have people been working around this? Why hasn't Microsoft fixed this
yet? It seems like a pretty major bug to me.