Access Problem !

[Diab]

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

PLS HLP THX

[Supester]

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?

[Diab]

Sorry ...

I Want Tha Value Of The Field Number To Be Equal To :

Number = 2^(Index-1) ..... (<Index> The Field )

Thanks

[Supester]

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?

[Diab]

Finaly I Explane My Self Good !

So I Know How To Do This From VB
I Need To Do it In The Accsess

Thanks !

[Supester]

Why not do it similarly then? Use a query to retrieve the values and write the squared values back....

[Diab]

How Can I Do THIS

[Supester]

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

[Supester]

halfway there

while not rs.eof
'do something with the rs
currentdb.execute yournewquery
wend

hope this helps.....