I have a query with [FacilityAmount] and [Amount].
There are 3 Facilities and each has an [Amount] (this is the amount drawn)
I need to show the [AvailableAmount] for each Facility, which is found by [FacilityAmount] and [Amount]
I think it is quite simple but I dont know how to do it.
I think it will be more clear if you open the attached db and look at the query.