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

 

Khalid-

Something like this:

IIf([InvoiceRate] <= 0.5, [InvoiceRate] - 0.05, [InvoiceRate] - 0.1) As PriceCutFactory

On the design grid:

PriceCutFactory: IIf([InvoiceRate] <= 0.5, [InvoiceRate] - 0.05, [InvoiceRate] - 0.1)

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Dec 20, 2015, at 6:38 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___