473,797 Members | 3,196 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Unbound control changes sorting of data

3 New Member
I am using Access 2007. Created a contribution database for a non-profit. Created parameter query that displays contributions for a specified time period using the "Between [Beginning] And [End]" parameter. The query sorts by company then last name. Created a report that uses the query as the data source. Displays data per the query. When I put an unbound control in the Report Footer or Header to count the number of contributions the names get sorted by First Name. The same happens if I delete the count and add an unbound control to sum up the contributions. If I delete the unbound controls then the sort goes back to Last Name. Can not find the problem. Created the report twice with the same effect.
May 13 '10 #1
5 1980
NeoPa
32,579 Recognized Expert Moderator MVP
Do you have Sorting and Grouping set in this report?
May 14 '10 #2
John McAtee
3 New Member
@NeoPa
No. I do not need any grouping and I did the sort in the query. adding that unbound control in the footer changes the sort from Last name to First name
May 14 '10 #3
NeoPa
32,579 Recognized Expert Moderator MVP
You need to set your sorting up in the report under Sorting and Grouping.
That's your problem then. You need to set the sorting in the report as otherwise it will make it's own mind up as to which sort order suits it best.
May 14 '10 #4
John McAtee
3 New Member
@NeoPa
That indeed was the problem. Thank you.
May 19 '10 #5
NeoPa
32,579 Recognized Expert Moderator MVP
A pleasure John :)
May 19 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
7659
by: mork | last post by:
I've got a form with AllowEdit = False. On it is a tab control, one of the tab pages has an unbound listbox which fetches data from another table. I am unable to select items in the listbox. Seems a bit odd that AllowEdit disables unbound controls. Is there a work-around to this? Have I overlooked something?
2
1709
by: Georges Heinesch | last post by:
Hi. I cannot change the value of an unbound control (txtSR and txtSS) within a sub call. I explain ... my sub (SRSS_set) takes the date (type date) as input, and returns 2 values (type time). Public Sub SRSS_set(varDate As Variant, _ varSR As Variant, _ varSS As Variant)
0
1465
by: Bob Bykerk | last post by:
Hyperlinks work fine when using bound controls but when I try to get one to work on an unbound control (with hyperlink? = true) I can't insert a hyperlink or use the data as a hyperlink. I have gone down the unbound forms route as this looks to be the most reliable and fast method. How can I get this to work?
3
2359
by: Trevor Hughes | last post by:
I am trying to resolve a problem I'm experiencing in Access 2000. I have an unbound control which is set be code on the open event of a form. However when I try to subsequently run some code which references the value in the unbound control, the code cannot see the value set. If however I manually type in the value into the unbound control the code works fine. I have tried to Refresh and Repaint the form, but this does not solve the...
1
2682
by: Jim M | last post by:
To prevent data corruption I have replaced a memo field on my form with an unbound control on my form that I populate with a function that fills it from a memo field from my table. When the form is closed, another function in a query writes it to the memo field. No trouble. When I run spell check on the form it makes the corrections in the memo field, but does not save them when I write from the form: I put this in the AFTERUPDATE...
0
1151
by: Barbara Schmidt | last post by:
Hello, if I get the data from db with sqldatasource-control, how to show this data to an unbound control, so for instance: label1.text=sqldatasourceWHAT-TO-DO-NOW Thanks Barbara
3
2015
by: scott_baird | last post by:
Probably something simple, but it's driving me up the wall... In a report, I have an unbound control that is the total of 2 other bound controls (currency) as follows: unbound control =cash1 + cash2 However, it is possible that either cash1 or cash2 can be null, in which case the unbound control displays nothing (apparently, addition only works with a zero or above). What I want to do is something along
1
3892
by: jjjoic | last post by:
Hi, I use Access 2003 to generate the back-end data for a ColdFusion report at work. The report is sorted by a column and based on the sorting, rankings are assigned to each row(i.e. the biggest value gets No. 1, and then the row of the second biggest value is ranked as No. 2). Each task owners will then have to attack their owning issues based on the ranking. The No. 1, 2, 3,... rankings are generated in this way: 1. An...
1
7192
KevinADC
by: KevinADC | last post by:
Introduction In part one we discussed the default sort function. In part two we will discuss more advanced techniques you can use to sort data. Some of the techniques might introduce unfamiliar methods or syntax to a less experienced perl coder. I will post links to online resources you can read if necessary. Experienced perl coders might find nothing new or useful contained in this article. Short Review In part one I showed you some...
3
7348
KevinADC
by: KevinADC | last post by:
If you are entirely unfamiliar with using Perl to sort data, read the "Sorting Data with Perl - Part One and Two" articles before reading this article. Beginning Perl coders may find this article uses unfamiliar terms and syntax. Intermediate and advanced Perl coders should find this article useful. The object of the article is to inform the reader, it is not about how to code Perl or how to write good Perl code, but to teach the Schwartzian...
0
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9537
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10209
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7560
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6803
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5459
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5582
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4135
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3750
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.