whileprintingrecords formula

[teqtaq]

Hello, I am re-creating Crystal report in Access.
I see whileprintingrecords formula in ther.

What does it do?
Can I have an equivalent in Access?

 

[CR85user]

Perhaps you ought post in an Access forum?

'J

CR8.5 / CRXI - Discovering the impossible

 

[teqtaq]

I would but first I want to know what this formula doing - I might don't need it. Thanks

 

[IanWaterman]

Its used to evaluate variables at that point whilst printing. ie if formula is placed in group header it is evaluated every time that group header is printed.

If it was whilereadingrecords it would only evaluate once.

Ian

 

[chelseatech]

Crystal does 2 or 3 passes of the data while it is processing the report. You can control when a formula is evaluated.

I'm not sure you can even do this in MS-Access. This is one of the reasons Crystal is a superior reporting tool. If it's an important formula you might find it can't be calculated in MS-Access.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm