G
Guest
I'm still a bit new to building expressions in Access. I've been working in
a query, on sales data.
The sales date table has "Date", "Quantity", "Taxable Items Price",
"NonTaxable Items Price".
I've created subtotals by creating the following expressions:
Subtotal Taxable: ([Quantity]*[Taxable Items Price])
Subtotal Nontaxable: ([Quantity]*[NonTaxable Items Price])
These both work.
But when I try to create a new column to get a total to use in another
place, neither of the following expressions work:
Total Sales: ([Subtotal Taxable]+[Subtotal Nontaxable])
Total Sales: ((Quantity]*[Taxable Items Price]+[Quantity]*NonTaxable Items
Price])
What am I doing wrong, or what should I be doing?
(Using trial version of Office Pro 2007)
Thanks for any help you can provide.
a query, on sales data.
The sales date table has "Date", "Quantity", "Taxable Items Price",
"NonTaxable Items Price".
I've created subtotals by creating the following expressions:
Subtotal Taxable: ([Quantity]*[Taxable Items Price])
Subtotal Nontaxable: ([Quantity]*[NonTaxable Items Price])
These both work.
But when I try to create a new column to get a total to use in another
place, neither of the following expressions work:
Total Sales: ([Subtotal Taxable]+[Subtotal Nontaxable])
Total Sales: ((Quantity]*[Taxable Items Price]+[Quantity]*NonTaxable Items
Price])
What am I doing wrong, or what should I be doing?
(Using trial version of Office Pro 2007)
Thanks for any help you can provide.