If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
Changing Fields
"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) |
#3
|
|||
|
|||
Changing Fields
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) . |
#4
|
|||
|
|||
Changing Fields
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) . |
Thread Tools | |
Display Modes | |
|
|