get a form check box to display a number in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use a check box on a form which will display a number when I run a
report from the table the form is linked to
 
What sort of number do you want it to display? A checkbox is a Boolean
control, so getting -1 or 0 to display is fairly easy. Is this what you want
or are you wanting a count of true records? If the latter, try using
DCount() and make the report textbox a calculated control.
 
I want to use a check box on a form which will display a number when I run a
report from the table the form is linked to
Click to expand...


You haven't given a heck of a lot to go on here, so maybe this will
help:

=IIf(forms!FormName!CheckBoxName = -1,A number value,"")

and then, maybe not!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
running a query & displaying a report 9
Display Combo box result in Report 1
Report Help 1
Query linked to a check box? 2
Have a Report Image Show or Not 2
Table headers in a list box (Custom Report) 3
Report based on form value 7

Back
Top