Nope, it didn't work? I even tried this to see if it
would work:
=(([CMCR Table]!SalePrice)+([CMCR Table]!SalesTax)-([CMCR
Table]!Discount)-([CMCR Table]!Deposit))
Here is the SalesPrice one: Perhaps this is the problem?
=(([CMCR Table]![Set-up Surcharge])+([CMCR Table]![Audio-
Visual Surcharge])+([CMCR Table]![Hosted Bar PP])+([CMCR
Table]![Cash Bar Hourly])+([CMCR Table]![Drink Tickets
PP])+([CMCR Table]![Hors D'oeuvres PP])+([CMCR Table]!
[Entree 1 PP])+([CMCR Table]![Entree 2 PP])+([CMCR Table]!
[Entree 3 PP])+([CMCR Table]![Desert PP])+([CMCR Table]!
[Wedding Cake Surcharge])+([CMCR Table]![Candlebra
Surcharge])+([CMCR Table]![Champagne Toast Surcharge])+
([CMCR Table]![Tables Surcharge])+([CMCR Table]![Guest
Book Table Surcharge])+([CMCR Table]![Gift Table
Surcharge])+([CMCR Table]![Linens Surcharge])+([CMCR
Table]![Napkins Surcharge])+([CMCR Table]![Centerpieces
Surcharge])+([CMCR Table]![Dance Floor Surcharge])+([CMCR
Table]![Media Show Surcharge])+([CMCR Table]!
[Entertainment Surcharge])+([CMCR Table]![Photographer
Surcharge])+([CMCR Table]![Florist Surcharge])+([CMCR
Table]![Favors, programs, decorations surcharge])+([CMCR
Table]![Service Charges])-([CMCR Table]!Discount))
Any ideas?? ha ha ha .. it is a long one. Thanks for
your help in advance.
-----Original Message-----
Try this instead:
= ([CMCR Table]![SalePrice]) + ([CMCR Table]! [SalesTax]) -
([CMCR Table]![Discount]) - ([CMCR Table]![Deposit])
Note: the equals sign needs to be there.
I am having trouble attempting to figure out how to
perform calculations in fields? Can anyone tell me what
I am doing wrong? I am in the Control source of
properties for this particular field, and this is what I
have for my expression:
( «Expr» = [CMCR Table]![SalePrice] + [CMCR Table]!
[SalesTax] - [CMCR Table]![Discount] - [CMCR Table]!
[Deposit] )
Thanks
.
