I have an Access Dbase that pulls data into a few tables and runs a query. The report that I am generating calls from the query:
1. Customer_ID,Customer_FName,Customer_LName,Customer _Addy and a few other fields. I concat the Customer_Fname and Customer_LName into one field. I need to sort the customer names Alpha, but adding sort to either the query or the subheader in the report dont have any affect on the data.