Incorrect numbering on report for one user

G

Guest

A report out of my Access database numbers items by group as well as overall
in two different colums. This is a report that does not require the user to
enter any parameters. You just click the button and the report is generated.
It works for everyone but one user. When she runs the report the items do not
number correctly. The same number repeats randomly in each group. When the
report is printed - same results. Anyone else can run the report from varying
security groups including hers and use the same or different printer and it's
fine. Anybody else encounter this problem??
 
L

Larry Linson

M Goodwin said:
A report out of my Access database numbers items by group as well as
overall
in two different colums. This is a report that does not require the user
to
enter any parameters. You just click the button and the report is
generated.
It works for everyone but one user. When she runs the report the items do
not
number correctly. The same number repeats randomly in each group. When the
report is printed - same results. Anyone else can run the report from
varying
security groups including hers and use the same or different printer and
it's
fine. Anybody else encounter this problem??

Basically, all you've said is "something doesn't work", so it'd be hard for
anyone to know if they had the specific problem. Perhaps you could clarify:

As Ross Perot said, "The Devil's in the details." What do you mean by "items
do not number correctly"? You have to do something to number items -- how
are you doing that? How, if at all, does the user id, or computer name of
the user, or whatever distinguishes one user from another, enter into the
numbering, or into the report, in any way?

Larry Linson
Microsoft Access MVP
 
G

Guest

I am numbering by the following expressions in the Control Source:
=IIf([SortCode]="99",0,1) name WrapTally named WrapTally with a running sum
OverAll
Visible is set to 'No"
=IIf([T7-PROGRAM.PROGRAM CODE]="WRAP-FOCUS"," ",[WrapTally]) named Text70
because I only want the WrapTally number to appear under that condition

That Text70 numbering is the one that is messed up and only for one person
when she runs the report. It's fine for everyone else.

If that's not clear enough we can just let it go. The person having the
problem doesn't work here anymore. I was just curious to see if anyone else
had experienced a similar problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top