Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Best way to add info to a table or query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bejewell - 03 Mar 2006 15:17 GMT
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.
Klatuu - 03 Mar 2006 16:01 GMT
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.

> This is probably a very obvious question, but being new to Access I am
> looking for some help...
[quoted text clipped - 15 lines]
> Any help?  Sorry, I'm sure this is an easy fix, but I'm just not familiar
> enough with Access to see it.
bejewell - 03 Mar 2006 16:13 GMT
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?

> 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
[quoted text clipped - 20 lines]
> > Any help?  Sorry, I'm sure this is an easy fix, but I'm just not familiar
> > enough with Access to see it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.