Code:
=IF(A1="";"0";SUMPRODUCT(POWER(36;LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))));(CODE(UPPER(MID(A1;ROW(INDIRECT("1:"&LEN(A1)));1)))-48*(CODE(MID(A1;ROW(INDIRECT("1:"&LEN(A1)));
Rolandas
Last Activity: May 12 '11, 06:27 PM
Joined: Mar 8 '11
Location:
-
Thanks for the answer. The algorithm is clear. Another question: Perhaps there is a function in excel which converts from base 10 to base 36? This function is opposite. It converts numbers from base 36 to base 10:
... -
Convert decimal to 36-base system
Hi,
Can anyone help me?
I need a code in VBA which would convert decimal numbers to the other system bases on number 36.
e.g. in this page http://www.translators cafe.com/cafe/units-converter/numbers/calculator/octal-to-decimal/
decimal to base-36.
Can anyone help me with that? -
If it didnt help what could I say then?
I solved this question simply aplying append query. It helped because I used 2 primary keys.Leave a comment:
-
Outer join doesnt help. Can You write the sql statement?Leave a comment:
-
Update table from other table
Hello,
I have one table which I want to append it with new records, e.g. let's call this table TABLE1. The table from which I want to append is TABLE2. This table is made from queries, so it is always different.
table examples:
TABLE1:
ClientID |Date |Information|.. .
123 |1/1/11/ |abc
123 |2/1/11/ |def
456 |1/1/11/ |ref
456 |5/1/11 |abc... -
Calculations in access queries
Hello everybody,
I am calculating NAV (net asset value) of portfolio with access and I am interested if it is possible to do some calculations. Here is example:
In one column I have the value of portfolio, e.g.
Value
99999
88888
77777
88888
66666
99999
I need the other column with would be like this:
Value| Unit Value
99999| 1000... -
You see, if I use a regular sum query, I get such table
Date | Value|
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 14
4/1/2010 | 10
5/1/2010 | 10
6/1/2010 | 10
7/1/2010 | 10
8/1/2010 | 8
9/1/2010 | 10
10/1/2010 | 10
I need to get this:
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 14
4/1/2010 | 14
5/1/2010 | 14
...Leave a comment:
-
Thanks for the answer, but what aggregate function do you mean? DSum? When I do that I get those rows sumed where the date is the same. But I need to hold that value for the next records as I explained with an example in the question.Leave a comment:
-
Data calculation in access like in excell
Hello Dear All,
I would like to know if it is possible to make calculations in access like in excell. I thing there are some ways to do that but I dont know how? Your help would be really appreciated.
Example:
I have table with values:
Value
10
15
30
20
10
And I need to insert into the same table the other column with percentage changes of... -
How to Join sum the values in two tables in access?
Hello,
I would be reallu grateful if someone could answer my question. I have two tables. The first table is with date and value. The same is another. e.g.
Table 1:
Date | Value|
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 10
4/1/2010 | 10
5/1/2010 | 10
6/1/2010 | 10
7/1/2010 | 10
8/1/2010 | 10
9/1/2010 | 10
10/1/2010 | 10
Table 2:...
No activity results to display
Leave a comment: