Sorting Records In A Query

Nov 9, 2005

I am having a problem sorting records in a query. I have about 5, 000 entries in a table and when I build my query based on certain fields, the numbers in certain columns are not in order although I use the sorting feature. ( e.g.) I have 5 columns with numbering data contained in the columns, and I have it set up to sort in ascending order, which it did, but I noticed that the Volume # column sorts the Volume numbers differently (see example below):

V. 1
V. 10
V. 11
V. 12
then it goes back to
V. 2
V. 3
V. 4
V. 5
V. 6
V. 7
V. 8
V. 9

It looks like it sorts anything with a 1 first then the rest later. How do I fix this?

Thanks.

View Replies

Sorting Records

Mar 11, 2005

I'm new to this but I am currently working on a DB for work. We are tracking employees that are trained by using an "X" in a Field to signify that they are in the process of being trained. Once they are trained they will enter the date it was completed. I need a query that will give me the number of "X"s and the number of dates. Currently it only gives me the total for all "X"s and dates. Is it possible to split the fields in a query and further receive the percentage of each including how many employees do not have any "X"s of dates? Any help would be greatly appreciated. I hope that this make sense.

View 8 Replies View Related

Sorting Records In A Lookup

Jan 23, 2008

Hi all,

Pretty straight forward question but I can't seem to find the answer anywhere on the net. I have a table with a text field that's values are pulled from another table via the Lookup Wizard. Everything works fine, and I now have a drop-down box that displays all of the fields I have set up with the Lookup Wizard.

But, how do I sort the records that appear in that drop-down? They are not ordered in the same way that the table they are pulled from is, nor do they seem to be ordered based on any one column.

Any help is much appreciated.

View 14 Replies View Related

Sorting Records After The Last Space

Oct 10, 2006

Hello all,

I have a field in a database that has people's full name (e.g. Jane B. Doe). I would like to sort by their last name. Can I build a query that looks at everything after the last space in their name? Thanks in advance.

Ron

View 4 Replies View Related

Sorting Records By Times

Jan 23, 2008

ok so im not sure how to explain this but ill give it my best shot.

I have an excel sheet that has a list of order info. heres a sample of what it looks like:

70144:37.0Starting order split <34010993;01>gregory_pm34010993
70245:16.0Script complete for <34010993;0106>Rx <24073318>gregory_pm34010993
70103:37.0Starting order split <34010995;01>knox_br34010995
70204:26.0Script complete for <34010995;0101>Rx <24239630>knox_br34010995
70126:49.0Starting order split <34011015;01>flander_ar34011015
70232:09.0Script complete for <34011015;0101>Rx <24008174>flander_ar34011015
70134:01.0Starting order split <34011015;01>flander_ar34011015
70127:08.0Starting order split <34011061;01>flander_ar34011061
70227:26.0Script complete for <34011061;0105>Rx <24240139>flander_ar34011061
70227:55.0Script complete for <34011061;0103>Rx <24240083>flander_ar34011061
70152:00.0Starting order split <34011173;01>parker_tp34011173
70252:46.0Script complete for <34011173;0101>Rx <24071140>parker_tp34011173
70103:35.0Starting order split <34011369;01>sexton_pa34011369
70204:00.0Script complete for <34011369;0101>Rx <24240569>sexton_pa34011369
70149:02.0Starting order split <34011668;01>knox_br34011668
70250:59.0Script complete for <34011668;0104>Rx <21441348>knox_br34011668
70134:20.0Starting order split <34011764;01>hicks_jo34011764
70234:44.0Script complete for <34011764;0102>Rx <22787965>hicks_jo34011764
70235:06.0Script complete for <34011764;0101>Rx <22787933>hicks_jo34011764
70236:11.0Script complete for <34011764;0103>Rx <22788283>hicks_jo34011764
70156:45.0Starting order split <34011855;01>knox_br34011855
______^this line is the time

ok so here is my problem. I need two records, one for the start of the order(the earilest time) and one for the closing of the order(the latest time). I also need the time inbetween the two.

Thanks!

View 3 Replies View Related

Sorting Records In Access DB

Apr 6, 2005

I have an ASP file that retrieves records from an Access database and displays them in the browser. The problem is that the records come out unsorted. I need to sort them by entry date. I have a field in the table called "EntryDate" that is in the format MM/DD/YYYY. Can I sort by this field? If so, what would the SQL statement be? Thank you.

View 2 Replies View Related

Sorting Records In A Report

Jul 30, 2005

Is there a way to Sort records in a report by a Report total? I have a report that is created by a crosstab query that sums orders by Billing Client but the query also has a billing client qroup which can contain many Billing Clients. Since the report total (Counts) are by Billing Client I do not have the actually totals per client group in the query to sort by. I know how to do this in Crystal Reports by the report would needs to mulpiple workstation, which have the crystal reports engine but not the actually designer (In other works I don't know the code to print a crystal report from Access with only the crystal reports engine on the workstation).

View 2 Replies View Related

Sorting Of Records In Text Box In Form

Dec 7, 2004

I have a text box called tboWorkstream on a form. I can scroll through the records using the navigation bar at the bottom. However, I want the records to be sorted by the Workstream Column, not the Workstream ID column (which is the primary key.)

Is there a way to do this?

I know you can list the way you want in a combo, but not sure how you do this in a bound textbox.

Thanks

sunil

View 3 Replies View Related

Forms :: Sorting Records In A Form (subform)

Jan 7, 2015

How to sort entered records in a subform by combo box. Notice combo box has integer value not text. I want to bo sroted by text visibled ASC. The code must be in Command control SORT (See pict enclosed)

View 2 Replies View Related

Forms :: Sorting Records In A Combo With Code?

Apr 25, 2014

Can you have a saved (unsorted) query as a row source for a combo and then add some code to enable the combo to sort the list?

Reason is, I want three combos to use the same query for finding records in different ways, but need the query to be saved, not a query built by the query builder that access takes you into from the row source on the combo data tab?

I only need the data listed in each of the combos to be sorted by one column in each of the combos.

Have seen something about bubble sorting, but not sure if this is OTT or even could be applied to this?

FYI, this is not a cascading situation.

View 2 Replies View Related

Queries :: Sorting - Show Records From This Week Only

Apr 23, 2013

I'm doing a query and I want it to show records from this week only.

Is there a formula I can use in criteria?

View 3 Replies View Related

Sorting A Table, Apply The Sorting To A Form

Mar 10, 2006

Hi all.
I've created a database which contains information about stores. I want to have the forms automaticly sorted by the department number.
I've tried to sort the table by department, but when I try to add a department, the sorting doesn't seem to affect the form at all.

Lets say I have department 1,2,3,6,7,8 in the form, and I add department 4, it will be the last post in the form. I want it to be the fourth, and so on..

I'd apreciate some help with this :) Thanks

Here's the database (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12934&stc=1&d=1142018915&PHPSESSID=f730b7f11f6983965698faeacbe5a1ee)

View 5 Replies View Related

Help With Sorting A Query?

Aug 9, 2007

I have a job database where I sort jobs by upcoming, inactive, closed and active. Each has a corresponding number 1-4 respectively. The main table I update the jobs in is the JOB TABLE. I print a weekly report for our weekly meeting but I only want the active jobs in the report. My question is: how do I perform a sort function in the query, so I will have only the active jobs in the database table show in the query? Thanks in advance! If more info is needed I wil post additonal.

View 4 Replies View Related

Sorting In A Query

Feb 1, 2007

I'd like to sort in my query - used to populate a combo box - first by name, and then by ID.
Is there a way to force Access to sort in a particular order? It seems like it starts sorting with the first field that's to be sorted, but I want it to start with field 2 and then sort by field 1.

View 2 Replies View Related

Sorting A Query

Feb 6, 2008

I am fairly new at relying heavily on Access for my programming. Problem: I have a telephone database with call detail for every call. I only want specific records, which I am pulling by selecting sort (in query design mode) for that particular field. I need to sort like you would in Excel (Column A first, Column B second, and etc). Can someone help direct me in the right path as to how I need to run a mulitple sort? Your help is much appreciated.

View 1 Replies View Related

Sorting Further From A Duplicates Query

May 13, 2005

I have a Duplicates Query that extract the following information from my Table

Name Surname DOB Joined

The query then extracts info such as...

Bill Smith 25:12:70 1999
Bill Smith 25:12:70 2005

Most of the time the 'Joined' field has the same year. But I need to find the ones where the year differs but the rest of the information is exactly the same. Because there is 15000 odd records to check, I thought that there would be a quicker way to check.

Could someone please assist me with this query if it is possible?

Thank you in advance.

View 1 Replies View Related

Sorting Crosstab Query

Jul 12, 2005

I have a crosstab query where my column headings are the names of the months based on invoice dates.
what i currently have:
Month: MonthName(Month([AnnualIncome]![InvoiceDate]))
so this spits out April May and June in the column headings.
The problem is that it is sorting it alphabetically, not by the numerical value - so my column headings are coming out as april, june, then may. (I assume once I have july that will come in between april and june.)

Any help would be REALLY appreciated.

Thanks in advance.

View 4 Replies View Related

Sorting Query Results

Apr 28, 2006

Hi

I have a problem sorting some query data and I wonder if someone could help point me in the right direction.

I have a query with two columns, in the first column is a number (either 6 or 7) and the second is the name of a business. Eg

Column 1 Column 2
6 Pizzas & Co
6 Pizzas & Co
7 Pizzas & Co
6 IPM Ltd
7 IPM Ltd
6 Computer Sales Ltd
6 Computer Sales Ltd
6 Computer Sales Ltd
7 Computer Sales Ltd
7 Computer Sales Ltd
7 Computer Sales Ltd
7 Computer Sales Ltd
7 Computer Sales Ltd

And I want to produce some another query so that the output which looks like:

Column 1 Column 2 (6's) Column 3 (7's)
Pizzas & Co 2 1
IPM Ltd 1 1
Computer Sales Ltd 3 5

So for each company name, I am essentially doing a frequency count for all the 6's and 7's.

I think this must be relatively easy to do, but I am getting it wrapped around my head!

Many Thanks,
Lee

View 2 Replies View Related

Sorting Subset Within A Query

Nov 24, 2014

How to sort a subset in a query. I have three fields BatchID,Month and Year. The BatchID can have multiple months and years. I would like to order the final sort so as the Batchs appeared in the order of the highest date combination with in each Batch.

The following is the SQL of my first Query which establish's the lowest and highest date in each batch.

Code:
SELECT tblRevOnlySelYear.BatchID, tblRevOnlySelYear.OperatorID, Max([Year] & IIf(Len([Month])=1,0 & [Month],[Month])) AS Expr1FROM tblRevOnlySelYear
GROUP BY tblRevOnlySelYear.BatchID, tblRevOnlySelYear.OperatorID
HAVING (((tblRevOnlySelYear.OperatorID)=1))
ORDER BY Max([Year] & IIf(Len([Month])=1,0 & [Month],[Month]));

The next SQL is the second query which results in the Batchs in the correct order by year but the months are not correct.

Code:
SELECT tblRevOnlySelYear.BatchID, tblRevOnlySelYear.OperatorID, tblRevOnlySelYear.Month, tblRevOnlySelYear.Year, qryRevTest4_1.[1stDate], qryRevTest4_1.LastDateFROM qryRevTest4 AS qryRevTest4_1 INNER JOIN tblRevOnlySelYear ON qryRevTest4_1.BatchID = tblRevOnlySelYear.BatchID
WHERE (((tblRevOnlySelYear.OperatorID)=1))
ORDER BY qryRevTest4_1.LastDate;

View 8 Replies View Related

Sorting Query By Date & Employee Name

Apr 3, 2007

I created a query which at first was simply to run a query which asks you for a drivers name, however we have decided that now we want to sort by the employee name as well as by a specified date range. I originaly had it set up to select the driver name with this in the criteria field in the Driver Name column:

[Enter Driver Name]

Then I tried to enter the following in to the criteria field in the date column:

Between [Enter Start Date: (Format MM-DD-YY)] And [Enter End Date: (Format MM-DD-YY]

However when I run the query it asks me for the date about 4 times, and then it goes to a blank report. I am sure I am not doing this properly somehow, anyone care to help out?

View 1 Replies View Related

Queries :: Sorting A Field Within A Query?

Feb 5, 2014

I have a query that pulls info from a table. One of my fields is frequency and in that field i have weekly, annually, daily, etc.

How can I make the query sort starting at the daily one and move out to annually?

View 2 Replies View Related

Queries :: Sorting A Query In Unconventional Way?

Aug 1, 2015

I want to sort the results of a query as follows.

The query returns 4 fields
ID, Field1, Field2, Field3

For the first 500 rows I want to sort by Field1 with the remaining rows sorted by Field3.

I can identify the first 500 rows bi ID being less than 501.

I've done something similar where I've displayed a value of a field in a different order by coding something like

ORDER BY Iif([field3]=9, 0.5, [field3])

which sorts the 9's first followed by the rest in ascending order but can't work out what to do here.

View 14 Replies View Related

Sorting Of Query In Subform Doesn't Happen

Nov 6, 2006

Hi,

I have a query for a subform which is displayed in datasheet mode (see attachment). I've created a form based on a query and used it as a subform.
The "casenumbers" per clients are displayed from 1 and upwards, I would like to have them sorted Descending. So in the query I sorted them that way. When I run the query they are displayed in descending order. When I open the subform based on that query however it is not. I can sort descending anyway by clicking the column on which I want to sort and do it that way, but that becomes bothersome and it doesn't need to be that way.

Record source is ok:
SELECT KlantNAW.ClientNumber, CaseInfoTable.Casenumber, CaseInfoTable.DateInitialCall, CaseInfoTable.DateCaseCreation, CaseInfoTable.CaseAccepted, CaseInfoTable.[1stAppointmentDate], CaseInfoTable.DateCaseClosed, CaseInfoTable.About1 FROM KlantNAW INNER JOIN CaseInfoTable ON KlantNAW.ClientNumber=CaseInfoTable.ClientNumber;

Order by:
Casenumber DESC

I thought, well, lets create a new form based on the query to see if that changes anything, maybe I've changed something I shouldn't have.

But nope, same result.

How can make the form sort descending in datasheet mode?

View 1 Replies View Related

Reports :: Sorting By Date In Query For A Report

Jul 27, 2014

I have a query where I ORDER BY ClientId, MatterId and Transdate. The result of the query is correct. All of the transdates are in ASC order within the Matter.

When I run the report for a MatterId the relative transactions are not sorted on transdate

Can there be something in the report that could be effecting the order of the transactions.

View 3 Replies View Related

Reports :: How To Combine Queries Into A Summary Query Of Sorting

Mar 21, 2013

i intially, I wish to have attendance stats for 3 groups of people over 2 days in a report

i have the two queries for the raw data, but wish to combine into a report that will ultimately become a "dashboard" report for half a dozen queries., and can only get one or the other to work do i need to combine the queries into a summary query of sorts?

View 1 Replies View Related

Sorting Table / Query - Ordering Numeric Values

Dec 30, 2013

I currently have records that end with a letter and 2 numbers. For example, A1, A2, ... , A10, A11. When I try to sort my table/query by these values, A10 & A11 come before A2. It seems that it is sorting by the first digit shown. Is there any way to fix this quickly within table/query properties so that this can be displayed in proper numeric order?

View 7 Replies View Related