Consult to Insert Data

G

gatarossi

Dear all,

I'm trying to insert into another table (ex. table2) some information
from one table (ex. table1), but in one field of table2 I would like
that the consult to insert data put YES for each data added in table2.

How can I do this?

Thanks!!!

André.
 
J

John W. Vinson

Dear all,

I'm trying to insert into another table (ex. table2) some information
from one table (ex. table1), but in one field of table2 I would like
that the consult to insert data put YES for each data added in table2.

How can I do this?

Create an Append query with a calculated field containing the YES - if it's a
yes/no datatype field, use True or -1.

John W. Vinson [MVP]
 
G

gatarossi

Dear RuralGuy/John

John, I think you understand my problem; in one field I need to put
Yes/No, but in another field I need to put some text information. Is
it possible?

RuralGuy, I'm afraid, because I don´t need to turning OFF the Warning
Messages, because I'm doing it in the excel.

Thanks a lot!!!

André.
 
J

John W. Vinson

Dear RuralGuy/John

John, I think you understand my problem; in one field I need to put
Yes/No, but in another field I need to put some text information. Is
it possible?

RuralGuy, I'm afraid, because I don´t need to turning OFF the Warning
Messages, because I'm doing it in the excel.

Thanks a lot!!!

André.

If you are doing this in Excel, you would do better to ask in an Excel
newsgroup. This newsgroup is for the database software Microsoft Access, not
for Excel.

To put text into another field... just put the text in the other field in
exactly the same way. I'm not sure I understand the problem.


John W. Vinson [MVP]
 

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


Top