conditional statements

[misschanda via AccessMonster.com]

Hello,
I have a report, based off many tables.... in the Final report (which
include other subreports) i would like a checklist.

for example if field results are all under requirements than I would like for
the check yes to be checked. if any or one result is over than check no.

for another check, if the field qualifer is filled than the check box will
automatically check no if not than yes.

how is this done

 

[golfinray]

You usually put check boxes on a form. Make a new field in each table and
make the datatype yes/no. Then put the checkbox on the form and it will store
the results in the table.

 

[Duane Hookom]

You can generally grab a check box from your tool box and drop it on your
report. Then set its control source to and expression that evaluates to
either True or False like:
=[Color] = "Red"
You haven't provided near enough information for us to supply your
expressions.

 

[misschanda via AccessMonster.com]

Hello,
thanks for the reply.

sorry for the lack of information.. I meant to say.. if in a another table,
all results for a particular field are under the recommended amount in the
final report there will be a label that says "did test meet limits". if this
is true than the check box will be checked. Is there away to associated the
check box based off table that holds the data for all records for a
particular ID.

so for instance, orderid 333 is below

[Test] [Weight] [Limit]<-- limit is same for all test associated with
weight.
2 200 199
3 175 199
4 164 199

in the final report, i would like for the check box to be empty because all
three results did not meet limit.

thanks,

chanda

You can generally grab a check box from your tool box and drop it on your
report. Then set its control source to and expression that evaluates to
either True or False like:
=[Color] = "Red"
You haven't provided near enough information for us to supply your
expressions.

You usually put check boxes on a form. Make a new field in each table and
make the datatype yes/no. Then put the checkbox on the form and it will store

[quoted text clipped - 11 lines]

 

[dhookom]

I'm not sure where the records are coming from that must be queried for the
checking. However, your check box expression could be something like:
=DCount("*","UnknownSource","[Weight]<[Limit] AND orderid =" & [orderid]) = 0

Duane Hookom
MS Access MVP

Hello,
thanks for the reply.

sorry for the lack of information.. I meant to say.. if in a another table,
all results for a particular field are under the recommended amount in the
final report there will be a label that says "did test meet limits". if this
is true than the check box will be checked. Is there away to associated the
check box based off table that holds the data for all records for a
particular ID.

so for instance, orderid 333 is below

[Test] [Weight] [Limit]<-- limit is same for all test associated with
weight.
2 200 199
3 175 199
4 164 199

in the final report, i would like for the check box to be empty because all
three results did not meet limit.

thanks,

chanda

You can generally grab a check box from your tool box and drop it on your
report. Then set its control source to and expression that evaluates to

[quoted text clipped - 7 lines]