Hi
In My Table There Are Two Fields Index(the key) and number
I Want To The Number To Be As Defult
2^(Index-1) How Can I do This ???:confused: :confused:
PLS HLP THX:rolleyes:
Printable View
Hi
In My Table There Are Two Fields Index(the key) and number
I Want To The Number To Be As Defult
2^(Index-1) How Can I do This ???:confused: :confused:
PLS HLP THX:rolleyes:
Hi
In My Table There Are Two Fields Index(the key) and number
I Want .....
this is what I understand and then u lose me.....
can you rephrase the question?
Sorry ...
I Want Tha Value Of The Field Number To Be Equal To :
Number = 2^(Index-1) ..... (<Index> The Field )
Thanks
:D :D :rolleyes:
so if i understand u correctly:
table
index - Number
1 1
2 4
3 9
something like this?
do you do this directly in Access or using VB?
Finaly I Explane My Self Good !:o
So I Know How To Do This From VB
I Need To Do it In The Accsess
Thanks !:cool:
Why not do it similarly then? Use a query to retrieve the values and write the squared values back....
How Can I Do THIS :(
Public Sub AA()
Dim rs As Recordset
Dim squery As String
squery = "SELECT * FROM Table"
Set rs = CurrentDb.OpenRecordset(squery)
while not rs.eof
wend
MsgBox rs.RecordCount
End Sub
the keyword here is
halfway there
while not rs.eof
'do something with the rs
currentdb.execute yournewquery
wend
hope this helps.....