From: CoralMelroe on
How do I add sales tax in my database query?
From: Steve on
Are all items taxable?

Do you expect the taxrate to ever change?

Steve
santus(a)penn.com


"CoralMelroe" <CoralMelroe(a)discussions.microsoft.com> wrote in message
news:47CDC808-954B-415E-97BD-C63E2C02BBAC(a)microsoft.com...
> How do I add sales tax in my database query?


From: John W. Vinson on
On Tue, 6 Apr 2010 16:22:01 -0700, CoralMelroe
<CoralMelroe(a)discussions.microsoft.com> wrote:

>How do I add sales tax in my database query?

By using an appropriate expression.

For a more detailed answer please post a more detailed question, including
information such as the structure (fieldnames, datatypes) of your table,
whether you need to deal with multiple tax rates or just one, whether some
items or some customers are tax-exempt, what's the context (on a form, a
report, in a query...?)
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: permissible characters
Next: Tables