can query pick from 4 diffrent field and put it all records in on colum.

  • Thread starter Thread starter Mike Saifie
  • Start date Start date
M

Mike Saifie

Can I creat a query which pick from four diffrent fieds and put it in one
colum. Or creat a new table and put it on one colume.
Like copy all the records from one field and then second and third and
fourth, then paste them in one field.

thanks
Mike
 
Mikke:

You could write an expression that checks different fields and choose one of
them.

Example:

Query has three fields for Phone numbers: HomePhone, WorkPhone, CellPhone

you could write an expression in a fourth field like:

MainPhone: iif([HomePhone] Is Not Null, [HomePhone], iif([WorkPhone] Is Not
Null, [WorkPhone], iif([CellPhone] Is Not Null, [CellPhone],"No Phone
Available")))

Obviously, you have decide the order of importance and place them in that
order.

Let me know if this helps.
 
Back
Top