Tickbox on a report

Dr_Worm

Dr_Worm

Board Regular
Joined
Jul 28, 2003
Messages
103
I have a form where I put in yes or no and the run a report. What I want to happen is at the top of the report, if I selected yes "Major Projects" will be displayed, and if no, "Minor Projects".

Thanks for your help
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Create the control in the report and link it's control scource to the form.
=IIf([Forms]![MyForm]![MyControl]=Yes,"Major Projects","Minor Projects")

HTH

Peter
 
Upvote 0
It didn't work at first, It needed quotation marks around "Yes".
=IIf([Forms]![MyForm]![MyControl]="Yes","Major Projects","Minor Projects")

This web site is brilliant :coffee:
 
Upvote 0
You must log in or register to reply here.

Similar threads

bobgrand
  • Question
New to Access - Build a Project Tracking Sheet
Replies
3
Views
642
Micron
M
K
  • Question
Runtime Error 3420 on Requery
Replies
7
Views
553
Micron
M
JenniferMurphy
  • Question
How to structure a variable product rating database
Replies
5
Views
820
mdmilner
M
K
  • Solved
Automaticaly Sum multiple fields in a form
Replies
9
Views
939
welshgasman
welshgasman
K
  • Solved
Change Excel cell color based on Yes \ No Access form Field result
Replies
3
Views
729
Micron
M

Forum statistics

Threads
1,221,570
Messages
6,160,560
Members
451,656
Latest member
SBulinski1975

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top