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 Replies
ADVERTISEMENT
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
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 3 Replies
View Related
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
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
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
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
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
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
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
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
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
Jun 14, 2007
Hi Everyone,
Could anyone tell me how I sort a field so it sorts by the surname, not the first name? It's one field with 2 names seperated by a space, i.e. George Michael.
Many thanks for any help.
Essex
View 5 Replies
View Related
Jan 1, 2008
I am doing a database containing names, dates of birth, dates of death etc of my ancestors. Does anyone know the best way of displaying it so I can sort them out by age of death? For example, I want to see someone for example who died aged 70 years and 6 months to be a place above someone who died aged 70 years and 4 months.
View 1 Replies
View Related
Jun 26, 2007
In Quebec there are a lot of place names beginning with "Saint-" or "Sainte-".
When I do an ascending sort on the table itself, these type of names don't seem to follow the expected pattern.
For the names Sainte-Marthe, Sainte-Thérèse, Saint-Ephrem, Saint-Eulalie I should see this order:
Saint-Ephrem, Saint-Eulalie, Sainte-Marthe, Sainte-Thérèse.
Instead, I get Sainte-Marthe, Saint-Ephrem, Sainte-Thérèse, Saint-Eulalie.
The names are spelled exactly as I have them in the table with hyphens and diacritic marks.
Any ideas why there seems to be a problem sorting "Saint-" from "Sainte-?
View 8 Replies
View Related
Jan 10, 2007
Yet another question! When I run the report, it gives me the results in alphabetical order (i.e. April August, etc) instead of monthly order... Is there a way to fix this?
Thanks!
Michele
View 5 Replies
View Related
Jul 26, 2007
I have a field with addresses (numbers and letters) Whenever I try to sort it sorts by the number. How do I get it to only sort by the letters but still include the numbers in the result?
View 1 Replies
View Related
Oct 4, 2005
I have been trying to solve this Access problem for a couple of weeks. I have 2 Access 2002 files where I import info from a Paradox DB. I have been doing this for 12 years. I just bought a new laptop and transferred the programs over (I didn't reinstall because I don't have a floppy drive). Paradox files have a default of an International sort order.
One of my 2 Access files is now requiring an Ascii sort order. The Paradox forum says that something in the Access file is asking for the Ascii sort sequence. I have to keep bouncing back and forth in the Regedit changing the sort order from International to Ascii and back again to use the 2 files.
Do you know how I can make the 1 Access file ask for the International sort order?
View 4 Replies
View Related
Jan 11, 2006
I have a table with an alphanumeric field I want to sort on. If I sort the usual ascending way, data that is numeric is sorted before data that is alpha.
Is there a way to have the alpha data sorted ascending come out ahead of the numeric data srted ascending?
Ex:
Currently,
1
2
3
A
B
c
Desired:
A
B
C
1
2
3
Thanks in advance to all who reply!!!
View 3 Replies
View Related
Jan 25, 2006
i have a simple datsbase with 2 fields - drawing number and description.
the drawing numbers are in the formatt STD123 e.t.c.
When I try to sort numerically the order ends up as
STD1
STD10
STD11
STD100
STD101..........
How do I get it to list in true numeric order in report and table view i.e.
STD1
STD2
STD3.......... Please bear in mind that my knowledge of Access is VERY limited. I've tried a search and don't understand about queries and such like. Even so I'd have thought that even the most basic database programmes would be able to handle something as simple as an alpha/numeric sort list....seems not!!!!!
????????????????
View 8 Replies
View Related
Mar 30, 2006
I have a table with two columns
skill and category
i need to write some type of query or report that will group the skills into the numerical categories 1-9 and then in each of those groups listthe skills autamaticall and then have a way to print it out either in word or excel looking some thing like this
category 1
askill
bskill
cskill
category 2
askill
bskill
cskill
.....
any ideas?
View 1 Replies
View Related
Feb 28, 2007
How can I sort string addresses so as to get the correct number order? I know that strings sort on each character, which causes the problem. I have tried some things (with VAL and Len), but was not completely successful. I do not want to enter an address number as 0630, when I want 630.
Why does this not work:IIf(Len(Str(Val([address]))=3),"0" & [address],[address])? Address has 3 and 4 numbers only.
View 2 Replies
View Related
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
Jan 23, 2006
Hey everyone,
Is there any way that you can do a secondary sort on a field?
Any help would be of great!
Thanks - edawson
View 2 Replies
View Related
Sep 1, 2006
Hi The beginner here again.....
How do I set a table to sort by specific fields???
ie i have an ID field which is an autonumber, then 6 fields
I want the table to autosort first by a field called [rank], and then by a field called [name]
Thanks in advance
Egg
View 8 Replies
View Related
Jan 27, 2007
I have a table of plant names such as
×Mahoberberis
+Crataegomespilus
Iris
Scilla
Hebe
Geranium
Acorus
Note that the multiplication and plus signs are part of the names.
If I sort the table (A-Z) I get
+Crataegomespilus
×Mahoberberis
Acorus
Geranium
Hebe
Iris
Scilla
What I would like to see is
Acorus
+Crataegomespilus
Geranium
Hebe
Iris
×Mahoberberis
Scilla
I am not a programmer so need to be led by the hand, but can anyone see a way of achieving this which I could copy? My simple mind tells me that I have somehow to suppress the × and + during the sort. But how?
View 3 Replies
View Related
