Best way to add info to a table or query

This is probably a very obvious question, but being new to Access I am
looking for some help...

I am tracking registrants for a conference, some of whom will be exempt from
paying the attendance fee. I would like to create a form that lists the
registrants who *might* be exempt, and then add a checkbox for the DB user to
indicate if the registrant is exempt or not. I would then like to store this
data in the master list of registrants, so at any time I can pull up my
master list and see all registrants and whether they are exempt or not.

I've created a query of all registrants, and based on that query I've
created another that lists possibly exempt registrants. I've created a form
based on the "possibly exempt" query, but when I try to create a checkbox in
that form to indicate if the entry is "exempt," I am having trouble.
Perhaps this is because there is no "exempt" field in the query, but so far I
haven't been able to figure out how to add a new field in a query.

Any help? Sorry, I'm sure this is an easy fix, but I'm just not familiar
enough with Access to see it.

For this you will first need to add the field to the table. It should be a
Yes/No data type. The open your query in design view and you will then be
able to add the field to the query. To make it show only those exempt, put
True in the Criteria row for the field.

"bejewell" wrote:

This is probably a very obvious question, but being new to Access I am
looking for some help...

I am tracking registrants for a conference, some of whom will be exempt from
paying the attendance fee. I would like to create a form that lists the
registrants who *might* be exempt, and then add a checkbox for the DB user to
indicate if the registrant is exempt or not. I would then like to store this
data in the master list of registrants, so at any time I can pull up my
master list and see all registrants and whether they are exempt or not.

I've created a query of all registrants, and based on that query I've
created another that lists possibly exempt registrants. I've created a form
based on the "possibly exempt" query, but when I try to create a checkbox in
that form to indicate if the entry is "exempt," I am having trouble.
Perhaps this is because there is no "exempt" field in the query, but so far I
haven't been able to figure out how to add a new field in a query.

Any help? Sorry, I'm sure this is an easy fix, but I'm just not familiar
enough with Access to see it.

Thanks so much for your response - I've tried this, but have not been able to
add a new field to the table - this table is linked to an online text file
and apparently I am unable to change properties of a linked table. Is there
any way around this?

"Klatuu" wrote:

For this you will first need to add the field to the table. It should be a
Yes/No data type. The open your query in design view and you will then be
able to add the field to the query. To make it show only those exempt, put
True in the Criteria row for the field.

"bejewell" wrote:

This is probably a very obvious question, but being new to Access I am
looking for some help...

I am tracking registrants for a conference, some of whom will be exempt from
paying the attendance fee. I would like to create a form that lists the
registrants who *might* be exempt, and then add a checkbox for the DB user to
indicate if the registrant is exempt or not. I would then like to store this
data in the master list of registrants, so at any time I can pull up my
master list and see all registrants and whether they are exempt or not.

I've created a query of all registrants, and based on that query I've
created another that lists possibly exempt registrants. I've created a form
based on the "possibly exempt" query, but when I try to create a checkbox in
that form to indicate if the entry is "exempt," I am having trouble.
Perhaps this is because there is no "exempt" field in the query, but so far I
haven't been able to figure out how to add a new field in a query.

Any help? Sorry, I'm sure this is an easy fix, but I'm just not familiar
enough with Access to see it.