create another table field from existing ones

smurf01 · Nov 14, 2003

Is it possible to create data in another table field from data in other table fields i.e.

FieldC
If([fieldA]= "YES",1,0)

I've probably not explained myself too well but any help would be appreciated

Regards

Paul

Golom · Nov 14, 2003

Select ..., IIF([FieldA]="YES",1,0) As [FieldC], ...

smurf01 · Nov 14, 2003

Golom, this may seem like a stupid question but where would i put this code

Regards

Paul

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

create another table field from existing ones

smurf01

IS-IT--Management

Golom

Programmer

smurf01

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor