how do I attach a value to a check box in access 2007?
Thanks - this helps!
"KARL DEWEY" wrote:
A check box will return a value of -1 (minus one) or 0 (zero) as it is
checked or not checked.
Your design is wrong. Based on what you posted you need three tables.
tblOrder --
OrderID - Autonumber - primary key
OrderDate - DateTime
OrderFor -
DeliverDate
OrderedBy
tblItems --
ItemID - Autonumber - primary key
ItemName
Size
Color
Price -
tblOrderItem --
OrderItemID - Autonumber - primary key
OrderID - number - foreign key
ItemID - number - foreign key
QTY
Use a form/subform for Order/Items with Master/Child links set on OrderID.
Use a combo to select items to be on the subform.
--
Build a little, test a little.
"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.
|