G
Guest
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.
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.