adding fields in Make-Table query 1

[hengsin]

i am writing one make-table query. I want to add another two fields on the new table. Match (Yes/No) and Comment (Text field). Is it possible?

Thanks

 

[dhookom]

You can create calculated columns in a make table query. Try add two new columns:
Match: True
Comment: ""
The Match column may create an integer field and the Comment field will have a zero-length-string in each value. If you had a two field, one record table with a yes/no and text field, you could add this to your maketable query to get the two extra fields.


Duane
MS Access MVP

 

[hengsin]

thanks, what if i want to create the Match field to Combo Box with only Yes and No instead of Boolean?

 

[dhookom]

I would never ever use a lookup field defined in a table. Create your user interface features into your forms not your tables. I never use input masks, lookup fields, captions, sub-datasheets,...

Duane
MS Access MVP