Access Prints a Negative Number

  • Thread starter Thread starter Bill K
  • Start date Start date
B

Bill K

When printing a very large document, the total Page
number is negative (Page x of -21699). The real total is
48,167 (a diff of 22,168). What is causing this problem
and how can I fix it?

I have tried deleting the Page x of y from the footer and
reinserting it, but this has not corrected the problem.

Hope this is not a limitation of MS Acces.
 
Bill said:
When printing a very large document, the total Page
number is negative (Page x of -21699). The real total is
48,167 (a diff of 22,168). What is causing this problem
and how can I fix it?

I have tried deleting the Page x of y from the footer and
reinserting it, but this has not corrected the problem.

Hope this is not a limitation of MS Acces.
Click to expand...


It sure sounds like an unsigned integer going from 15 bits
to 16 bits, except that you numbers don't add up to that.

I've never heard of anyone (except maybe Congress) printing
anything that big, so experience is nonexistent here. Maybe
you can get the proper number by playing around with an
expression along these lines:

="Page " & Page & " of " & IIf(Pages < 1, 32768 - Pages,
Pages)
 
This report is to provide data to the IRS (close to
Congress, but not quite). We would normally use SQL as
the database and Crystal Reports, but we need to provide
the file to the IRS. I'll work with your suggestion.

Thanks.

Bill
 
Bill K said:
When printing a very large document, the total Page
number is negative (Page x of -21699). The real total is
48,167 (a diff of 22,168). What is causing this problem
and how can I fix it?

I have tried deleting the Page x of y from the footer and
reinserting it, but this has not corrected the problem.

Hope this is not a limitation of MS Acces.
Click to expand...

I tend to agree with Marshall Barton - it sounds like an Integer versus Long
type of thing (but I can't make the math work with the example you
provided).

If you are using Access 2000, look for a online help entry entitled "Page,
Pages Properties." It might yield a clue. I found the page by using the
Index tab and entering the keyword "page_number."
 
Back
Top