Hi,
I need to run a make-table query to add certain records form one table into another. Is there a way to make a new Yes/No field in this new table which is NOT based on any field in the first table? Basically each new record should have a tick-box field, called 'PaidFor', defaulting to "not-ticked" when the query is run.
I've tried adding 'PaidFor:0' and 'PaidFor:No' and though these add the correct logical values to records in the new table, when I create a form based on that table, I can't seem to format the new field as a tick-box, whci is what I really need to do.
Can anyone advise how I should approach this?
I need to run a make-table query to add certain records form one table into another. Is there a way to make a new Yes/No field in this new table which is NOT based on any field in the first table? Basically each new record should have a tick-box field, called 'PaidFor', defaulting to "not-ticked" when the query is run.
I've tried adding 'PaidFor:0' and 'PaidFor:No' and though these add the correct logical values to records in the new table, when I create a form based on that table, I can't seem to format the new field as a tick-box, whci is what I really need to do.
Can anyone advise how I should approach this?