Changing Fields

  • Thread starter Thread starter Can I do this
  • Start date Start date
C

Can I do this

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 said:
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.
Click to expand...
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.
 
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
 
Back
Top