Append fields that contain yes/no datatype

  • Thread starter Thread starter Asha
  • Start date Start date
A

Asha

I have a need to append fields separtaed by commas to a
new field by creating a query. HOw do I do this using
Access query. Here is my structure:

id -primary key
first - text
last - - text
cable - yes/no
modem - yes/no
process - yes/no

I need to create a new field call totalequipment that
combines the name cable, modem, process if the value in
the field is 1 (meaning yes)


So here is an example of the output:
New column
id First Last Cable Modem process totalequipment
___________________________________________________________
12 Mark Phillips 1 0 1 Cable, process
 
Back
Top