Confused with report...

[stephendeloach via AccessMonster.com]

In my form i have a check box for Taxable and Non-Taxable. This form is used
for making invoices and sometimes we will need to tax some of the work that
is being done. (Where the check box comes into play) Then I have a report, in
the report I have a Taxable and Non-Taxable calculation box. This what is in
my box...

Taxable - =Sum(IIf([taxable_flag]=False,[quantity]*[unitprice],0))

Non-Taxable - =Sum(IIf([taxable_flag]=True,[quantity]*[unitprice],0))

Now when I open the report a param box comes up with taxable_flag on it. How
do I fix this? Thanks


Stephen

 

[Guest]

Instead of False and True in your statements try: 0 and -1

hth

 

[stephendeloach via AccessMonster.com]

I have figured it out. I needed to correct the spelling of taxable_flag in my
table. Everything is working smoothly! Thanks for the reply though!

Instead of False and True in your statements try: 0 and -1

hth

In my form i have a check box for Taxable and Non-Taxable. This form is used
for making invoices and sometimes we will need to tax some of the work that

[quoted text clipped - 10 lines]

Stephen