Changing Fields

I have Three Field:

A, B, C

A = 1

B = 0

C = Null

Any way from Access to Change C field to 100 if B field is
0 and C field to 0 if B = 100.

Thanks Kindly,

"Can I do this" wrote in message
...
I have Three Field:

A, B, C

A = 1

B = 0

C = Null

Any way from Access to Change C field to 100 if B field is
0 and C field to 0 if B = 100.

Yes with an update query but if those are the only two choice there is no
need for field C.
Use a query with C: IFF( B = 0, 100, 0)

Where can you do a update query? I am very novice, I am
usually using VB and don't have to deal with Access
directly.
-----Original Message-----

"Can I do this"
wrote in message
...
I have Three Field:

A, B, C

A = 1

B = 0

C = Null

Any way from Access to Change C field to 100 if B field
is
0 and C field to 0 if B = 100.

Yes with an update query but if those are the only two
choice there is no
need for field C.
Use a query with C: IFF( B = 0, 100, 0)


.

On the database window, click the Queries tab, then click New, add the
table, create a SELECT Query, run it to make sure it brings back the fields
you want, then on the Menu, Query | Update, and put the expressions in the
UpdateTo line.

If I am doing anything of any size like this, I do it on a _copy_ of the DB
until I am certain that it went OK.

Larry Linson
Microsoft Access MVP



wrote in message
...
Where can you do a update query? I am very novice, I am
usually using VB and don't have to deal with Access
directly.
-----Original Message-----

"Can I do this"
wrote in message
...
I have Three Field:

A, B, C

A = 1

B = 0

C = Null

Any way from Access to Change C field to 100 if B field
is
0 and C field to 0 if B = 100.

Yes with an update query but if those are the only two
choice there is no
need for field C.
Use a query with C: IFF( B = 0, 100, 0)


.