[MS_AccessPros] Unbound Text box on a report should meet the conditions required

 

Hi All,

I have a Report "Price List" its Record Source is a "qry Price List Report" having sql:

SELECT [qry Price List Report Base].ConsignmentNo, [Invoice Values PakCaspian Ammended].ProductNameEnglish, Products.ProductNameRussian, Products.UnitOfQty, [Invoice Values PakCaspian Ammended].InvoiceRate

FROM Products INNER JOIN ([qry Price List Report Base] INNER JOIN [Invoice Values PakCaspian Ammended] ON [qry Price List Report Base].ConsignmentNo = [Invoice Values PakCaspian Ammended].ConsignmentNo) ON (Products.ProductNameEnglish = [Invoice Values PakCaspian Ammended].ProductNameEnglish) AND (Products.ProductNameEnglish = [Invoice Values PakCaspian Ammended].ProductNameEnglish);

Sql of "qry Price List Report Base" is:

SELECT [Price List].ConsignmentNo

FROM [Price List]

WHERE ((([Price List].ConsignmentNo)=[Forms]![Dialog Price List]![cmbConsignmentNo]))

ORDER BY [Price List].ConsignmentNo DESC;

The report is OK except one thing which i need is that on the last Unbound Text Box "PriceCutFactory"

should give values according to the following conditions:

CONDITION-1.

InvoiceRate < 0.51 Then 

PriceCutFacotry=InvoiceRate - 0.05

CONDITION-2.

InvoiceRate > 0.5 Then

        PriceCutFacotry = InvoiceRate - 0.1

Need help in this issue.

Regards,

Khalid

__._,_.___

---

Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___