473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Sorting and Grouping Report - Please HELP!

Hi Guys,

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can choose a field and when they click the 'create report' button it will change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status or User etc...

Is this possible? does anyone know the code i can use in the 'create report' button...

Thanks for any suggestions!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
1 2440
Here is an example from the Help file that I believe does what you are
asking.

Private Sub Report_Open(Cancel As Integer)
Me.GroupLevel(0).ControlSource _
= Forms!SortForm!txtPromptYou
End Sub

The index number for the third group, where you have User, would be 2. You
can also add a new group level with the CreateGroupLevel method of the
Application object.

--
Wayne Morgan
MS Access MVP
"Jon via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:a7******************************@AccessMonste r.com...
Hi Guys,

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can
choose a field and when they click the 'create report' button it will
change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status
or User etc...

Is this possible? does anyone know the code i can use in the 'create
report' button...

Thanks for any suggestions!

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...
4
by: Marie | last post by:
My report has a text field named ItemNum. Most records have a value for ItemNum. I set Grouping And Sorting to sort ascending on the ItemNum field. The records where ItemNum is Null appear at the...
5
by: Mike | last post by:
Hello All, I have a report based upon a query. I have added a control to report footer that calcs the total cost of the inventory: =SUM(). When this total calculation is NOT on the report,...
8
by: nn0410 | last post by:
I have a report whose record source is a query. The query includes an ORDER BY clause that sorts on a particular set of columns. I would like to be able to run the same report with the same input...
3
by: Jimmy | last post by:
Is there a way to sort/group a report based on the second column of a combo box, i.e. the text associated with the primary key number?
3
by: Don | last post by:
I have a "Report" that is created from a "Form". It prints a list of items, you may consider it a shopping list. In any event I use to run this in alphabetical order but have since decided to run...
2
by: jonosborne | last post by:
Hi, i have literally been racking my brain about this one and i think i need some help. I have a report which is produced when a button on a form is pressed. The report has many fields and records...
5
by: Gumbyu | last post by:
Hello all, I have been working on this issue for about a week and still cannot get anything to group or sort. At this point, I just want to be able to group a report by using a 'checkbox' on a form....
4
by: kstevens | last post by:
I have a report, and on the report is a min, avg, and max query each with (ok who really cares) 20 or so records. At the footer of the report i would like to have a total. I requery for each...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.