April 28th, 2010, 09:28 PM
posted to microsoft.public.access.gettingstarted
|
|
|
how do I attach a value to a check box in access 2007?
Thanks, this helps!
"John W. Vinson" wrote:
On Tue, 20 Apr 2010 14:02:01 -0700, janelgirl
wrote:
In a database, there are several items in a single row that may or may not be
listed as yes/no in a checkbox format. When I transfer the information from
said database into a report, I filter the results to list only the items that
were checked "yes". Is it possible that the items that were checked "yes"
could return a value from a query on the report? For example, in the
database, I checked "flowers", "card", and "candies" for John Doe. A
seperate query has the individual costs that it takes for "flowers" or "card"
or "candies" . Those queries have their own totals (which may change as I
alter the info to reflect changing costs for materials). When I select "yes"
for "flowers" in the database, how do I get the report to show the total from
the query? Is this possible? I am new at access 2007 (and in general), so
please use basic language. Thanks in advance for any help that you may
provide.
Your table design is incorrect.
What will you do when you add another possible item? Redesign your table,
rewrite all your queries, redesign your forms, recreate all your reports?
OUCH!!!
If each person may get many different items, and each item may be taken by
many different people, a proper table structure uses *three tables*:
Individuals; Items; ItemsTaken. The third table would have links to the
primary key of the first two tables.
you might want to look at some of the tutorials here; Crystal's "Normalization
101" would speak to this issue:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--
John W. Vinson [MVP]
.
|