Minggu, 20 Desember 2015

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

 

John,


It worked perfectly.
Thank you very much.

Regards,
Khalid



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

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 
(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


__._,_.___

Posted by: khalidtanweerburrah@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Posting Komentar