Book Collection Database - How To Sort Columns In Ascending Order
May 28, 2012
My question is simple: I've got a database of my book collection. If i view it in a style sheet, it is something like
Author Title etc.
A 0
C 1
B 3
F 2
D 5
D 4
A 8
F 9
I would like to order the Author and Title columns (permanently). Particularly, I would like to order in alphabetical order all the authors and, if I've got the same author, order his/her book alphabetically, something like:
Author Title etc.
A 0
A 8
B 3
C 1
D 4
D 5
F 9
How can I achieve this?
View Replies
ADVERTISEMENT
Oct 2, 2005
Hello,
Is their a a way I can have a button or something in which duplicates all the data in the text boxes instead of re-entering data?
Also how can I sort data (DATES) that is in a form in descending order.
Thank you,
Onofrio
View 5 Replies
View Related
Feb 24, 2005
Goodday All
I am having a bit of a problem with one of my tables. I am using VBA code to add data to one of my tables, my problem is that even when I manually sort the table, it still gives me problem.
For example, I have a table that stores mobile numbers by year and month. I manually sort it by year- Ascending, but it still gives me this jumbled up table. I even tried writing a query to pull out the data and set the Sort by ascending and yet still it gives me this. What am I doing wrong?
MobileNo YearMonthRental Fees
+27241214282004Dec0.0089.60
+27245873742004Dec0.00607.89
+27256801612004Dec0.00607.89
+27245998662005Feb0.00246.00
+27246790232005Feb0.00246.49
+27249275562005Feb0.00335.96
+27278115852005Jan0.00782.04
+27249442532005Jan0.00357.40
+27278100662005Jan0.00137.70
Thanx for all the help
Kind Regards
View 13 Replies
View Related
Aug 15, 2006
I have query that uses the following forumla "Team HCP2: ([Member Frt HCP]+[Member Back HCP]+[Guest Frt HCP]+[Guest Back HCP])/2" to calculate team handicaps. The formula performs as I need it to but when I try to check the sort box to sort "Ascending" it asks for a parameter.
All I want to do is run the query and have the results of the calculation field sort the column of results in a ascending order. All non calculated fields in the query are sortable by using the sort by ascending feature in the design mode.
Best regards,
Dave
View 14 Replies
View Related
Nov 3, 2006
Hi,
I have a database of about 2300 entries and new ones are continually being added. However they are not always in numberical sequence, (eg. 604, 605, 606 etc.) sometimes they will be new revisions on an old number, (eg. 345R3, 604R1 etc)
I have noticed that in Access 2000, when you attempt to sort the numbers in to a numerical sequence, they dont always do it, they will go by the first number (eg. 1, 10, 100, 101 etc) How can i get it to go into a correct sequence (eg. 1, 1R1, 2, 3, 4 etc)??????
View 10 Replies
View Related
Jan 5, 2005
Hello,
I have a simple invoice database with a primary key in the main table (with autonumber as invoice no.) and a subform with the item details which is without a primary key with the data type as numbers. In addition, I had the tables linked as one to many relationship. What happen is that when I am entering the data, the number jumps . For eg: It was suppose to be 7123 but the next entry was 7150. Pls kindly advice.
View 3 Replies
View Related
Jan 4, 2006
Happy new year everyone.
I have a table in which the data input comes from a dropdown list selected in a form combo box as:
contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.
I am designing a report in which I want to display the above list in Ascending or Descending order but as shown rather than alphabetically.
What I mean is no matter how the information is on the table the report showd display it in Ascending as contract signed, PIN issued, etc and in Descending as CER's issued, EB approved, Host country approval , etc.
Any ideas?
Thank you
dfuas
View 6 Replies
View Related
Mar 6, 2015
I'm trying to sort and filter a continuous form. Sort ascending and filters works perfectly fine. But my descending button doesn't work. I basically have a combo box which contains a field list. Then two buttons (asc. and desc.), then a text box for filter, a button to filter, and another button to reset filter. Here's my code:
Code:
Private Sub cmdAscending_Click()
If IsNull(Me.cboField) Then
MsgBox "Please choose a field.", vbOKOnly, "No field to sort."
Else
Me.OrderBy = Me.cboField
Me.OrderByOn = True
[Code] ....
View 8 Replies
View Related
Apr 25, 2006
Hello all,
How can i get the records of a form based on a field ascending order (not the primary key), when i open it?
Thank you in advance.
View 3 Replies
View Related
May 19, 2006
Hello friends,
Please can anyone tell me how i can make the selections in my combo box (combo is bound to column1 of a table) appear in ascending order, by name (column2).
I.e. It's bound by column 1 (with is the Id#), but i want it to appear in ascending by column 2 (Usernames) to make selections easier. Please help :)
View 2 Replies
View Related
Jun 20, 2013
I am trying to export a data in Excel where a date field is in ascending order
But on displaying i am getting in ascending order but the display is somthing like this:
13/05/2013
13/05/2013
05/10/2013
05/10/2013
05/08/2013
05/08/2013
05/07/2013
05/07/2013
05/06/2013
05/03/2013
05/03/2013
05/02/2013
05/02/2013
30/04/2013
30/04/2013
Date order is misplaced...
View 5 Replies
View Related
Nov 14, 2012
I have a master/child forms. in master form sale_id,collection notes are placed. and in child form all collection details like collectionnumber,date,etc., child form look like datasheet view.
When i select the record from the list depending on the sale_id all the collection records shown in datasheet view form. If no record is there ok. if more than one records are there in collections of sale_id.i need count of records in collection depending on sale_id and also if i select one row in collection, notes to be shown for that record when i clik on shownotes button.
If more than one record in collection automatically it increment. how many collections for the sale_id. collection number would be increment. How and also show notes depending on collection number and sale_id.
View 3 Replies
View Related
Oct 10, 2005
How do you change a file's sort order from ascii to international?
View 3 Replies
View Related
Feb 11, 2007
Hi all, I am new to this site and I am hoping that I might be able to get some help with my database which records address information of people reqesting a brochure or making a hotel booking. The problem that I am having is that the addresses are sorting in post code order, I have selected remove filter/sort and this does not do anything. I would like the records to stay in the order that they are entered at I also use this for a merge with a brochure/deposit letter and it is much simpler if I can merge a block of entries.
Many thanks in advance Pat.
View 6 Replies
View Related
Apr 18, 2007
Supposed I have the following tables:
TableMonthlyReport consists of the following fields:
*IDStore
*Year
*Month
*IDCatalog
*IDItem
Quantity
TableGoods:
*IDCatalog
*IDItem
ItemName
IDSupplier
The asterisks indicates the index keys. While TableMonthlyReport has 2 links of relationship with the TableGoods on IDCatalog and IDItem.
I have a data entry front end for monthly report. I have no problem to have the record source for this purpose.
I just need that the sort order of the item (in the front end) in a way that they could be managed differently on different period. For example, in March to April 2007 I want the items shown in the following order: A B C D ... While in May to August 2007 I want the items shown as B D A C ....
I tried to create an order table just like this:
TableGoodsOrder:
*IDCatalog
*IDItem
*ValidStart
ValidEnd
OrderItem
It is linked with the TableGoods on IDCatalog and IDItem.
The first order list (March - April 2007) will have the ValidStart of 703 and ValidEnd of 704. While the next order list will have the ValidStart of 705 and 708. The last 2 digits stand for the month, while the first digit is to indicate year.
The SQL query for the record source works but I can not enter any value. So, the idea of having a special table for sort order is not OK.
Can anybody give me a clue for the solution?
View 2 Replies
View Related
Dec 6, 2005
I have a table in MS Access with records including dates. The dates are date/time data type and formatted as short dates. They display properly in the table.
However, when I run a query (SQL shown below), it sorts the dates strangely.
Any ideas??
SELECT DISTINCTROW Format$(tblChat.dtDate,'Short Date') AS ChatDate, Sum(tblChat.TCT) AS SumOfTCT, Sum(tblChat.NC) AS SumOfNC
FROM tblChat
GROUP BY Format$(tblChat.dtDate,'Short Date')
ORDER BY Format$(tblChat.dtDate,'Short Date');
Here’s an example of the sort order in the query.
10/31/2005
11/1/2005
11/10/2005
11/11/2005
11/12/2005
11/14/2005
11/15/2005
11/16/2005
11/17/2005
11/18/2005
11/2/2005
11/21/2005
11/22/2005
11/23/2005
View 2 Replies
View Related
Nov 3, 2006
Is there a way to sort dates using "Decending" but have blank dates stay on top?
I have a listbox based on a qurery that displays all pending and completed jobs. The query sorts (Ascending) the "Job Complete" date. This conveniently puts all of the pending jobs with null values at the top of the list. The bad part is that this puts recently completed jobs at the very bottom of a (thankfully) long list. Is there a way around this?
Thank you!
View 5 Replies
View Related
Mar 2, 2005
Okay, here's my new dilema. I'm in the military and rank is one of the fields in my DB. The only issue I'm having is that I would like to sort by seniority, not alphabetically. For Example, I've listed a few ranks below in the correct order from greatest to least. Is there some way that doesn't involve a page of code to achieve this? Thanks.
Colonel
Lt. Colonel
Major
Captain
1st Lt.
2nd Lt.
View 8 Replies
View Related
Mar 14, 2005
I have a query that fills a report that I have in an Access 2000 database. This report needs to be sorted by the following:
Code:ORDER BY tblPrimaryDept.PDName, tblSubDept.SDName, tblKeyStrategy.KSID, tblKeyInitiative.KIID, tblKeyDeliverable.KDID, tblSubDeliverable.TargetDate, tblQuarters.QID;
It's working fine, but .... (There's always a but)
tblKeyStrategy.KSID can be null, so therefore, it is sorted by null records, then ascending order tblKeyStrategy.KSID. What they client wants is it to be sorted by tblKeyStrategy.KSID first, then the null value ones.
ie:
So as it stands it currently does this:
Finance
Finance
Finance 1
Finance 2
Now they want it to do this:
Finance 1
Finance 2
Finance
Finance
Is there any way this can be done? I've been looking, but haven't seen anything regarding this.
Thanks for any assistance you can give me on this.
View 13 Replies
View Related
Mar 7, 2008
Hi all,
I'm quite new to access, and have a pretty straightforward problem (I hope):
I have a table with 300 records in 10 columns. I want to:
1. filter the data based on column A (gives me 150 visible records)
2. Copy from an excel spreadsheet which exactly matches the access table (single column only, 150 rows)
3. Paste into a new column I created in the access table
Unfortunately, when I hit paste in access, it loses the filter and pastes the data into the complete dataset (i.e. into the wrong records).
I've no idea why access won't keep the filter I set. I also tried numbering the records and sorting them based on this new column. Again, Access lost the sort order before pasting the data.
Help!
I really need to be able to paste my excel data into the table in access!
Can anyone shed some light for me?
Thanks in advance,
Lee
View 4 Replies
View Related
Apr 12, 2005
Hello,
This is related to "Old_value, new_value" thread I posted yestarday (Module&VBA).
I have a problem i missed yestarday. The code it's vorking great, but it allways takes the showed new_value and makes it old_value for the new record, and this is a problem, because the showed record is not the last for that customer.
So, I was thinking that if I make a new Autonumber field in my table, I could sort descending the values and this way the input form will allways show me the last entered data for that person.
As I noticed from a long time ago, if I sort a table that allready has a form, the form won't show the records sorted. Why? It's necessary to make the form again? I tried to order the data on the form from Properties window ->Data->Order by, but the ordering is Ascending and I need it Descending!
Can enybody help me?
Thanx,
Attila
View 1 Replies
View Related
Dec 7, 2005
i have a combo box on a payment form which shows existing permit #s. i'd like to make the sort order show the most recently added permit first. i clicked on the build button next to RowSource on the data tab of the properties of the combo box which opens the query my combo box is based on. there are only 3 sort order options...ascending, descending, & not sorted. can this be done?
the permits form has a button to open the payments form (payments can also be opened alone too - ie. if somone applies for a permit today but pays for it tomorrow...). usually this will not be the case but that is why i have to keep it either combo or list.
all help is appreciated.:)
View 3 Replies
View Related
Sep 15, 2006
I need to manage a list of, in this case "medications", with this list the most common "meds" are on the top of the list. there will be at times new "meds" added that should be at the top of the list. I want to create a unbound box that will let me drag the "meds" up or down in the list. The best emample i know of is the way you can set the "Tab" fields on a form to move the tabs stops.
View 4 Replies
View Related
Nov 29, 2004
How do I change the sort order to display on a form using an option button?
Thanks!
View 1 Replies
View Related
Apr 29, 2008
I am working with Access 2003 and want to save the sort order in a subform. The new sort order would be different from that of the underlying table. The Order By property has been set but isn't working the way I expected. I have tried replacing the underlying table with a query but that hasn't worked out either. I don't want to change the order of the table because other programs that access it would be affected.
I've been reading about an Order By On switch that might do the trick but apparently it's not contained in Access 2003. There must be some other way to skin this cat!
Thanks in advance.
View 4 Replies
View Related
Sep 13, 2013
I have a query that is returning running conditions for a machine over multiple shifts. the table is set up like this
Code:
date shift parameter condition
09/13/13 1 front 500
09/13/13 1 middle 450
09/13/13 1 back 475
09/13/13 2 front 510
09/13/13 2 middle 460
09/13/13 2 back 490
this is just a small example. there are about 24 different parameters reported on in a shift..I want the query to sort by date ascending, shift ascending, and then by parameter in a specific custom that i define. I want it ordered "front, middle, back" for each shift. Again this is just an example, there would be 24 parameters I want in a specific order. Then do I need to define the sort order again for the report based on this query?
View 3 Replies
View Related
