Search results

hi L, Sorry, I did not explain myself very clearly.. What I meant is that i have a series of exchange rates for every month for over a long period of time.. So, it's a whole series of factors that I have and not only one constant factor. What I want to do is multiply the rate of a specific...

Thanx, But what if the factor (the exchange rate) is changes every month? How do I do it then? Stacey

Hi LEn, what u mean is that I do not split up the query in the first place? In the original query I have (among other things) the following fields: COMPANY | YEAR | MONTH | RATES | CURRENCY Only for the companies with a specific currency I want to convert. But the problem is that there are...

Hi, I have a query in which I have rates a period of time for several companies. However, these rates can be in different currencies depending on the company. So, I created a a couple ( the number of queries depends on the amount of different currencies) of queries to convert all the rates in...

Thanx a lot.. i understand now what I was doing wrong.. Greets.. Stacey

hi RG, I see your point... How do u suggest I change it? I would like to use the convenience of the fact that it 'hides' some of the information. is a user select categoryID 1 for examples , it doesn't say anything to them, while if it says food they know what to select. Reason why i cannot...

Hi Rural guy, Im not sure I understand what u want me to change. What do u mean by " leave the lookup as textbox" ? if I leave it as a textbox, it doesn't define anything, i think. What I have is a Number field in my table with a listbox as the lookup. To clarify: I have somewhere a list of...

Hello.. In one of my tables I have a field with the following characteristics: Listbox row source: SELECT Category.CategoryID, Category.Category FROM Category ORDER BY Category.CategoryID; row source type: table/query bound column:2 column count: 2 This gives the user the opportunity to see...