how i seperate a data of one table using query, to another table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to seperate a data like YES/No from one column of an Access Database
Table into two seperate columns of another Access Table viz. column 1-->YES
and Column 2---> NO
 
Rather an unusual thing to do, but try:

INSERT INTO Table2 (Field1, Field2)
SELECT IIf(Field1, Field1, Null), IIf(Field1, Null, Field1)
FROM Table1
 
Back
Top