This is drving me crazy and I've tried suggested solutions which don't seem to work. I have a simple query which includes LastName and FirstName fields. I can sort the query just fine for LastName then FirstName. I created a Report based on this query but it doesn't sort. I read that you're supposed to sort the report and not the query but the sort and filter options are all greyed out. Can someone please tell me there is an easy solution? Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sort a query-based report
- Thread starter SMHSleepy
- Start date
I find it hard to understand the sorting and grouping are disabled in the report design view. One possible issue is if the fields are memo data type.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question
