Recent content by PhilUp

yes, I am restarting my project now. Thanks for reply, It works great

Hi Jdraw, I am getting error on line 160 - GetRoundedTo Compile error: Sub or Function not define Can someone help on that ? Thank in advance.

to clarify my previous post: Setting of the currency for the quotation is on the main form based on "Quotations" table. Currency of supplier is on continuous subform based on table "QuotationItems" table. All items in one quotations do not have the same supplier currency.

Ok, I am changing my approach to the exchange rate issue. I have now created currency sets, each set has one Xrate value based on a table where all Xrates are stored. The issue I am facing now is that I need to store the currency into the items table, so I can create a relation between the...

Xrate: IIf([QCur]="THB" And [SupplierQuoteCurrency]="CHF",[Forms]![Quotations]![QuotationItems].[Form]![TC], IIf([QCur]="THB" And [SupplierQuoteCurrency]="EUR",[Forms]![Quotations]![QuotationItems].[Form]![TE], IIf([QCur]="USD" And...

Thank you for your help. I did not post the full SQL from the query. The following id the formula I have in the query to pick up value for the "Xrate" field.

Thank Cronk, did as you suggested, but it is still not saving the value in the table....

Thanks a lot, will try it out soon and let you know.

Actually the query is running just fine. My problem is only to convert it to VBA.

Hi, I have one form to calculate selling prices based on various currencies and generating customer quotations. Exchange rates and other parameters are entered on the MainForm A SubForm is used and based on a query where I have all calculations in the query. The calculations are referring to...

Hi JDraw, Thank you so much for your help. Looks exactly right. I am just confused with the lines 20 to 80. Now you have the test values, but how to get the value from [MyField] ?

Hi GOP, Sorry for my late reply, I had some emergency. here are some samples: .1 > .1 112.3 > 113 169 > 169 1001.1 > 1010 12089.4 > 12090 85675 > 85680 100654 > 100700

Hit the wrong key, sorry start again.. Yes, I understand the Round function, but i am looking to round UP. According to Allen Brown, he recommends the INT function: " Rounding up To round upwards towards the next highest number, take advantage of the way Int() rounds negative numbers...

Yes, I understand the Round function, but i am looking to round UP. According to Allen Brown, he recommends the I

Hi, I have been searching and struggling with this for a while. I am looking to Round Up numbers as in Excel. I know Int function can be used as follow: Int(100 * [MyField]) / 100 Works well, however I want to have different roundings depending on the numbers. if value is between 0 and 1000...