C
CoachBarkerOJPW
I am trying to create a query for computing quarterly sales taxes. Doing a
computation for one quarter is simple, then I run into problems when I try
for the second quarter. So a couple of questions.
I can do the query from the table for sales where I can get the SalesID,Tax
Amount and Sale Date. I can do a sum of Tax Amount and then where the Sale
Date is between 1/01/2006 AND 3/31/2006 for the first quarter. But I can only
do one quarter at a time.
SELECT Sum([TaxAmount]) AS FirstQuarter
FROM tblSale
WHERE (((tblSale.DateOfSale) Between #1/1/2006# And #3/31/2006#));
Or should I create a new table for Sales Taxes like this and make the field
for the quartes a calculated field?
tblSalesTaxes
SalesTaxID
SaleID (to get the date and tax Amount)
Thanks
CoachBarkerOJPW
computation for one quarter is simple, then I run into problems when I try
for the second quarter. So a couple of questions.
I can do the query from the table for sales where I can get the SalesID,Tax
Amount and Sale Date. I can do a sum of Tax Amount and then where the Sale
Date is between 1/01/2006 AND 3/31/2006 for the first quarter. But I can only
do one quarter at a time.
SELECT Sum([TaxAmount]) AS FirstQuarter
FROM tblSale
WHERE (((tblSale.DateOfSale) Between #1/1/2006# And #3/31/2006#));
Or should I create a new table for Sales Taxes like this and make the field
for the quartes a calculated field?
tblSalesTaxes
SalesTaxID
SaleID (to get the date and tax Amount)
Thanks
CoachBarkerOJPW