Check box and make table query

A

angela

I am trying to write a very basic make table query pulling some of the data
from a form. the form has a check box, [MO] and a default value of -1 (this
is to defaul all records as checked)

If I run a datasheet veiw of the query, the table populates with the "-1"
when I run the make table the field shows ?? and a data type of bianary.

The query is pulling from the form as MOR:[forms]![Frm_RunNew]![MO]

If I uncheck the box it show zero on view and null when run.

any suggestions?
 
A

angela

I added Cbool to my query and all is fine now.. thanks to anyone who may have
taken the time to take a look at the issue.

Angela
 

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

Can rich text format (memo) carry over in a make table query? 1
Combine Duplicates in Query 0
Make Table Query Popups 9
Make table query: [Enter 1] AS Test 1
Access 2003 3
Daily Make Table Query 1
Make-table query with around 2 ml records taking too long 0
Query Make Table Name from Form 2

Top