By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Screen Preview differs from Print Out

P: n/a
Hi,

I made a report with Access 2000
I show records, plus a total of some colums.

I first had:
totalC = col1 + col2 + col3 + col4

Then I changed it to:
totalC = col1 + col2

On my screen preview, I get:
totalC = col1 + col2

But if I print my preview, I get:
totalC = col1 + col2 + col3 + col4

Can someone help me get the correct print out?

Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Y. Gauthier wrote:
Hi,

I made a report with Access 2000
I show records, plus a total of some colums.

I first had:
totalC = col1 + col2 + col3 + col4

Then I changed it to:
totalC = col1 + col2

On my screen preview, I get:
totalC = col1 + col2

But if I print my preview, I get:
totalC = col1 + col2 + col3 + col4

Can someone help me get the correct print out?

Thanks!


Are you sure you're getting the sum of the 4 columns and not double the
2 wanted columns?

What happens if you code the Report Header Format event:
[TotalC] = 0

Is the amount now correct in both preview and print?

--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
Nov 12 '05 #2

P: n/a
is there code in te OnPrint event?, or did the values change?

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"fredg" <fg******@example.invalid> wrote in message
news:wP**********************@bgtnsc05-news.ops.worldnet.att.net...
Y. Gauthier wrote:
Hi,

I made a report with Access 2000
I show records, plus a total of some colums.

I first had:
totalC = col1 + col2 + col3 + col4

Then I changed it to:
totalC = col1 + col2

On my screen preview, I get:
totalC = col1 + col2

But if I print my preview, I get:
totalC = col1 + col2 + col3 + col4

Can someone help me get the correct print out?

Thanks!


Are you sure you're getting the sum of the 4 columns and not double the
2 wanted columns?

What happens if you code the Report Header Format event:
[TotalC] = 0

Is the amount now correct in both preview and print?

--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.

Nov 12 '05 #3

P: n/a

Great!

I added the total initialization in the Header Format...

1000 thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.