question regarding checkboxes, tables, forms, & queries

[crispy02]

I am not sure where to start. First I havea form where a user enters data on a screen and check offs checkboxes and the data is saved in a table to be used later. Once it is in a table I read another table to get the value I want instead of the -1 that shows up.

My question is in a query I have Reason1, Reason2, Reason3, Reason4, Reason5 and I want to combine them into 1 "Reasons" and when I do that I get a -1 for the ones that are checked. If I query on them alone the value I assigned for each reason shows up. Can anyone help me.

I have attached my database in case someone can be of help.

Query -> EMF Contact Summary-chris
From -> EMF Contact Report- Chris

MainTable ContactInformation

All the data in the databse is just test data. I am just developing the database at the moment

 

[chewy]

if you cconvert it to access 97 I can take a look at it for you

 

[crispy02]

Here is the database in 97. Thank you for looking at this