Check box and make table query

  • Thread starter Thread starter angela
  • Start date Start date
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?
 
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
 
Back
Top