Access Problem !

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.....