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

Minggu, 20 Desember 2015

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

John,

Thanks for your reply, i will work on it at night and inform the output tomorrow. As up to evening i am at different job not having my database here.

Thanks a lot again.

Regards,

Khalid

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

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@... [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