hi, i used a make table query to make up a table. In one
of the column, i want to make it as combo box with only
two values: Yes, No.
CAn i do this in the Make-Table query?
A Table *CONTAINS DATA*. A Combo Box *is not data* - it's a tool to
manage data!
Table datasheets should be used *only* for debugging; they have very
limited capabilities compared to Forms.
Also, make-table queries are very, very rarely necessary. If you want
to display just selected records from a table, it is not necessary to
create a new table; just base a Form (or a Report, for printing; or an
export, to send the data outside Access) on a Select Query.
Could you describe the function of this table? Why do you feel that
you need to create it?