how do I attach a value to a check box in access 2007?

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.