Access Report: How can I manipulate the data before it's being printed

[Sammy25]

I have a query that queries multiple tables, and contains a calculated field. I am hoping to find a way where I can:

1. Change the forecolor of the field IF the calculated field = yes
2. Calculate the queried field by multiplying it by 10
3. After making these changes to the query, display the dynamically changed data in the access report


Can you, who are kind, please also show me the syntax that will be involve in this process.

Thanks very much

 

[ZmrAbdulla]

Hi,
Try conditional formatting from the Format menu while you are design viwe of the report. This is avilable if you are using Access2000 or higher.
for help try "conditional formatting" in help file
regards

Zameer Abdulla

http://www.geocities.com/zameerabd/