Approach to calculating projections

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Approach to calculating projections

Post by Leesha »

Hi,
I am looking for input in how to approach a report. I've attached the report that I have built. I think it is too busy/too much information. My goal is to limit the information based projected sizes. For example, if example if the "Amount Needed" is 4 ounces then "Conversion" would not show quart and gallon as they wouldn't be considered for use.

I was thinking of setting up a table to compare between conversion amounts but nothing Iset up seems to work. I am either making this much harder than it needs to be or, there isn't an option to providing the report as is and letting the user decide what option they want.

Thanks!
Leesha
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Approach to calculating projections

Post by HansV »

You might use code in the On Format event of the Detail section and of the header and footer of the group with the totals to set the Visible property of labels and text boxes depending on the unit of Amount Needed.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Approach to calculating projections

Post by Leesha »

Hi Hans!
Just tried it and that will do exactly what I'm looking for! I never think to code on the detail portion of the report as I usually get what I need in a query. This is so much easier!
Thanks again,
Leesha