Several problems

[Bergh]

Hi I have some problems. My english is not so very good so I hope that you understand.
1. I have boxes that I should calculate the length and width on, if I have 4 boxes that is 398cm length and 198cm width. Can I make a VBA code to calculate this??
I have two checkboxes to like this:
Quantity * length = sum (4*398=1592)
If one of the checkboxes is checked then it is /2 like this:


Quantity * length = sum /2(4*398=1592/2=796)
And if the second checkbox is checked then it is then width that should be calculated like this:
Quantity * width = sum (4*198=792)
And if both of the checkboxes I checked then it look like this:
Quantity * width = sum / 2(4*198=792/2=396)
And the sum that is longer than 1500cm will be red
How do I do this VBA code??
2. I have a number like 3 and when the calculated number is higher than number 3 then it will be red. (I have already made this calculate). But my problem is: I will make a report that only print the red numbers when I click on a button. (This has nothing to do whit the first question.)
3. How can I get a unbound control on a report?

See forward to your answers!!

/Bergh

[Jim Doherty]

Bergh....with respect your last line concerns me a little. If you do not know how to put an unbound control on a report then you need to learn how to do that first on both forms and reports as it is the fundamental element of Access. The rest will follow namely learning about 'Calculated' controls on forms and reports, embedded expressions and calculations in queries amongst other methods.

All of these calculations you speak about are achievable in VBA code. In short, you need to look at the IF statement or SELECT CASE statement to see how this deals with true false logic and practice with that.