DataEnvironment

[Jon Pad]

my problem is about the reports in the data environment where the results of the 2 columns will be attach in an unbound text box.
Sample
field1 + field2 = unbound text box.
the result will be viewed and print in the report design.

any help can do. thank you

[Aaron Young]

Make the Calculation a part of the SQL used as the source for the report, i.e. (Using NWIND.MDB as example):
SELECT *, (UnitPrice * UnitsInStock) as TotalPrice FROM Products


This way you can just add the field containing the calculation to the report like any other field.

Aaron Young
Senior Programmer Analyst
[email protected]
Certified AllExperts Expert: http://www.allexperts.com/displayExp...p?Expert=11884