Adding Tax to query

[Charlie2]

I have developed a query which adds accumulated costs for each client in my DB, I am having trouble adding the VAT tax which is 17.5% to the query though, I seem to get a lesser total once tax is added which can't be correct.

Here is my query:

SELECT DISTINCT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.[CostPerNight], Rooms![CostPerNight]*Nights_Stayed+Holiday_Bookings!Booking_Cost+Room_Facilities!FacilityCost AS TotalCost
FROM Room_Facilities INNER JOIN (Hotels INNER JOIN (Holiday_Bookings RIGHT JOIN Rooms ON Holiday_Bookings.ClientID=Rooms.ClientID) ON Hotels.HotelID=Rooms.HotelID) ON Room_Facilities.FacilityID=Rooms.FacilityID;

 

[Smart]

In your Query add a new column an type this in the field box
inc vat: [amount]*17.5/100+[amount]

(where [amount] is your amount field)

 

[Charlie2]

Thanks Man

That works great, but can you tell me how to format the result into currency, sorry to be such a dummy it's quite a while since I used this stuff.

 

[Charlie2]

Ah Got it

Will the currency formatting apply to any upsized data to MSSQL 2000?