Query Help Please

D

Dave

I am using MS Access 2010 I have this query.

SELECT [Soccer Regional].[Vendor Name], [Soccer Regional].[Invoice
Number], [Soccer Regional].[Invoice Date], [Soccer Regional].
[Player
Name], [Soccer Regional].[Invoice Total], [invoice total]*0.045 AS
State, [Invoice Total]*0.0325 AS City, [invoice total]*0 AS County,
[state]+[city]+[county] AS Total, IIf([Ball Type]="fine",
([Total]*0),
([Total]*0.0225)) AS Discount, [total]-[discount] AS Refund, [Soccer
Regional].[Claim Number], [Soccer Regional].[Permit Number]
FROM [Soccer Regional]
WHERE ((([Soccer Regional].[Player Name]) Not Like "*withdrawn*"
And
([Soccer Regional].[Player Name]) Not Like "*denied*") AND
(([Soccer
Regional].[Claim Number])="12-45E"))
ORDER BY [Soccer Regional].[Invoice Date];

Now I want to change the Total*0.0225 to calculate using the rate
2.25% only when the [Soccer Regional].[Invoice Date] is between
1/1/2000 thru 6/30/2010 and to calculate using the rate of 1.00%
when
the [Soccer Regional].[Invoice Date] is after 7/1/2010.

Can you please modify the above query for me to reflect the changes i
want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top