?
Solved

Access Rpt sort by Page head label

Posted on 2013-01-23
3
Medium Priority
?
400 Views
Last Modified: 2013-01-24
Using Access2000. My report is sorted by Bill number (qry).  Customer just has to have it sorted by contract name on  by clicking Page Header (label) too.
I donot want to create 2 queries and 2 reports. How this can be done with just one same report?
0
Comment
Question by:WTsuk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
jcrozier21 earned 2000 total points
ID: 38812026
Can you clarify? Hard to understand what your question is. If you just want to change the field that the report is grouped by try Allen's method http://allenbrowne.com/ser-33.html
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38813337
Access 2000 reports will not do that without closing and re-opening the report.
0
 

Author Closing Comment

by:WTsuk
ID: 38815463
I crated Continuous Forms with sorted by Command button and passed case SORT value paramater into report.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question