i have the following SELECT statement....
"SELECT PurchaseOrders_Detail.Product_ID, PurchaseOrders_Detail.Name, PurchaseOrders_Detail.Book_Price FROM ......etc.
This statement is being set in a list and will fetch the data from a query.
I want to have the fields, like Product_ID, Name, Book_Price.. appear with my own headings in the list.
Right now they appear as is... Product_ID etc. and there is no caption set in the query or the table so the the raw field name is displayed in the heading.
How can I set my own caption (heading name) by passing a SELECT statement to a list.