Sabtu, 19 Desember 2015

[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)

.

__,_._,___

Tidak ada komentar:

Posting Komentar