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

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
 
D

Douglas J. Steele

Rather an unusual thing to do, but try:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Parsing a table 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Using multiple databases 3
Replacing a Table with a Table from another database - reference issues 1
Linking accross sections 3
Changing a Table to a Linked Table? 4
How do I create a date from data in seperate columns 2

Top