Adding a yes/no field

[Leslie67]

I'm trying to pull data from 2 different tables to create a third and add a yes/no field. I have the table created, no problem, but now I need to be able to add the yes/no field.

I know that in Design view, for text, you put Variable:""

How do you add a yes/no field?

 

[GingerR]

a little confused, sorry.
you have the table created - so do you have the Yes/No field in the table already?
if you already have the table created, then you dont have to 'create' the yes/no field in a query. you just populate it with the query, for example

iif(X=Y,"Yes","No&quot

yes = true = checked = -1
no = false = unchecked = 0

you can use any of these above to designate the value of a check box.

am i totally off base? if so, please give more detail as to the problem. thanks--g

 

[Leslie67]

Sorry, I can see what I wrote was confusing <g>.

I have a &quot;make table&quot; query that pulls records from a table showing me duplicate information in certain fields. The only way that I can determine which record to keep is to visually compare them.

I would like to add a yes/no field to the table that results from my query, so that I can go down the list, check the ones I want to delete, and then run append and delete queries based on that checkmark.

Sooooo... what I need to know is: How do I add this yes/no column to the table that results from my original &quot;make table&quot; query.

Is that better?

 

[GingerR]

yes better thanks.
is this something you're doing one time only? or over and over again every day or week?
if one time only, just run the make-table query and add the yes/no field yourself manually. but i guess if that were the case, you wouldnt have a problem.

if this is something you will be doing repeatedly, the best thing would be to create the table structure, then use an Append query instead of a make-table query. each time you need to bring in the data, first run a DELETE query to empty out your table, the use an append query to add more. you can set this up in a macro so you dont have to run all the steps individually. will this work for you? using Make-Table queries bloats the database much faster than delete-then-append queries. you'll have to watch the size of the db anyhow, and compact now and then.

g

 

[Leslie67]

Actually, yes, this will work really well...

I get so stuck on doing things one way and making them work that I forget to look at the other ways.

So, thank you for your fresh eyes <g> and reducing my stress level by about 3 degrees. <bg>.