I have a query that I have created for a table that will sort text data, including values that look like numbers into a proper sort, i.e., 300, 385 427, 3085,, etc. rather than the default sort. I have two questions about creating a report using this query.
1. I created a report that has a prompt in the report header. The prompt is for data that is not in the underlying table and is just used for extra information. I created a text field for the prompt. When I run it, the prompt works fine, but it is overriding the sort in the query. If I put the prompt in the page header, my query sort works fine. Why is this happening?
2. Using the same query, I want to create a report that groups the data on the sorted field that I described above. However, when grouping is set in an Access report, it automatically sorts the data which overrides my query sort; so, the results are in the wrong order. Is there any way around this?
Thanks Judy
Update: I have uploaded a sample of my database in a separate message in this thread.
1. I created a report that has a prompt in the report header. The prompt is for data that is not in the underlying table and is just used for extra information. I created a text field for the prompt. When I run it, the prompt works fine, but it is overriding the sort in the query. If I put the prompt in the page header, my query sort works fine. Why is this happening?
2. Using the same query, I want to create a report that groups the data on the sorted field that I described above. However, when grouping is set in an Access report, it automatically sorts the data which overrides my query sort; so, the results are in the wrong order. Is there any way around this?
Thanks Judy
Update: I have uploaded a sample of my database in a separate message in this thread.
Last edited: