Kathyrlcrs
MIS
I am having to take a report from 9.0 and create it in 8.5.
I am using an access database.
I had this formula working in 9.0:
If Not IsNull({Brokerage_Offer.ReducedAmount})and ({Brokerage_Offer.ReducedAmount}) > 0 then
{Brokerage_Offer.ReducedAmount} else
{Brokerage.ListPrice}
I am using an Employee, Company and Brokerage table in addition to the Brokerage offer table.
For some reason this formula will not work in 8.5. It seems not to work when there is no Brokerage_offer record.
If there is no brokerage offer record it does not print any of that information for that employee.
How can I rewrite this formula to check for the no record.
If there is a Brokerage Offer record then I need to print that info, if there is not a Brokerage offer record then I need to print the data from the brokerage table.
The Isnull is not taking care of that in 8.5. It did in 9.0.
Any suggestions in how I can rewrite this formula?
Thanks!!
I am using an access database.
I had this formula working in 9.0:
If Not IsNull({Brokerage_Offer.ReducedAmount})and ({Brokerage_Offer.ReducedAmount}) > 0 then
{Brokerage_Offer.ReducedAmount} else
{Brokerage.ListPrice}
I am using an Employee, Company and Brokerage table in addition to the Brokerage offer table.
For some reason this formula will not work in 8.5. It seems not to work when there is no Brokerage_offer record.
If there is no brokerage offer record it does not print any of that information for that employee.
How can I rewrite this formula to check for the no record.
If there is a Brokerage Offer record then I need to print that info, if there is not a Brokerage offer record then I need to print the data from the brokerage table.
The Isnull is not taking care of that in 8.5. It did in 9.0.
Any suggestions in how I can rewrite this formula?
Thanks!!