Search results

thanks a lot. It works now dfuas

IIF function not returning the false value. I have the following results based on the query shown below. SELECT Trade.Ref_No, Trade.CERS_Price, Market.[USD/EUR_Rate], IIf("CERS_Price_currency = US Dollar.USD",[Trade].[CERS_Price]*[Market].[USD/EUR_Rate] , 0) AS [Price In Euro]...

What you say is true and I rather do it in the query than vba as I have really no clue how to start with it in vba, but the problem is: EUROAMOUNT: [rate] * [amount] the [amount] field is a dropdown currency which can be in 4 currencies (USD, Euro, BRL and INR) the [rate] are four checkboxs...

Hi, I have a query in which I try to calculate field values depending on the currency and foreign exchange rates. I have a currency field with the amount value and a combo box where I select the currency for that amount which can be (USD, Euro, BRL, or INR). I have got also another 4 fields...

thanks, I will try to work on that. dfuas

No I am working on a query and that query will be used to display the results for a report. but still you input is being helpful. thanks dfuas

Sorry on that, but will all the query be based on the vba or can I just obtain the results for that field using the code? can you give some clues, please, all these vba and integrating it with the query is news to me, but where there is a will everything possible. thanks

Thanks a lot. I could see the attachment, but the problem I have is that the rates are in a table and are all in displayed different textboxes, because I have another table of trade data with autonumber RefNo and each RefNo could have any of the 4 currencies. So on the calculation I need to...

sorry I don't understand this. the name is already in a combo. so with the amount I select the name of the currency and if is not already Euro it checks the values in xchange rate fields corresponding to the name of currency in the combo and the does the calculation depending on that. In one...

Hi, I have a query in which I try to calculate field values depending on the currency and foreign exchange rates. I have a currency field with the amount value and a combo box where I select the currency for that amount which can be (USD, Euro, BRL, or INR). I have got also another 4 fields...

that is really great. I can't thank you enough. dfuas

thanks, that is working just as I want it.

How would I add a year say 2006? Sorry this is first time i am trying this sort of query. thanks

Hi I have the following Access SQL query: SELECT Trade.Ref_No, Trade.Carbon_Project, Trade.HostName, Trade.Country, Trade.Retainer_fee_to_Receive, Trade.Fees_Payable, Trade.Due_Date FROM Trade WHERE ((Month([Due_Date])=[?] And Month([Due_Date])=[?])); I have put the information from WHERE...

Hi everybody, I have a report that is based on an underlying query.At the query level,I want to define parameters of date data type so that records to be displayed should fall between DateA and DateB. ie Between[Enter Date A:] And [Enter Date B:]. I want the DAteA and DateB to be only days...

Hi everybody, Is there a way to limit the number of characters displayed in a report. Say I have a word like "Internet" on a table but on my report I want only to see the first 5 characters to be shown, in this case would be "Inter". Is there a way to achieve this? Thanks dfuas

you are right. anyway I appreciate you input. I though about that sort sequence before but I have not enough experience to carry it out. I need more help here. Thanks a lot dfuas

Status contract signed PDD issued validation finished CER's issued contract signed PIN issued PDD issued PIN issued Host country approval received PIN issued Host country approval received PDD issued PDD issued validation finished Host country approval received Host country approval received EB...

It should be in that order: contract signed PIN issued PDD issued validation finished Host country approval EB approved CER's issued contract signed to CER's issued as Ascending and CER's issued to contract signed as Descending

SELECT [Trade].[Status], * FROM Trade ORDER BY "contract signed", " PIN issued" DESC , "PDD issued" DESC , "validation finished" DESC , "Host country approval received", "EB approved" DESC , "CER's issued" DESC; and I tried other combinations. But I may doing all wrong as well.