I have a table Payments which has a field called "PaymentDate" with it's
caption set to "Payment Date" Here is the SQL
SELECT Payments.PaymentDate AS [Date paid]
FROM Payments;

The querie's column heading is still "Payment Date".
OK, no big deal, but why doesn't the "Date paid" alias override the caption?
Is it a bug?

However
SELECT Payments.PaymentDate
FROM Payments;
with the caption property of the Query field set to "Date paid" works OK.
Does this mean that you can't write an SQL statement to show the column
headings you want if the table caption property is set?

Phil