Duplicate A Form And Sort A Form In Ascending Or Descending Order?
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 Complete Forum Thread with Replies
Related Forum Messages:
Ascending E Descending Order Of A Table.
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 Replies !
Saving Sort Order In A Form
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 Replies !
Help Sort Descending Asp/access
I have no experience with asp or access and I can not figure out how to get these queries to sort descending instead of ascending. Here is what I believe to be the loop: Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "SELECT TopRecord.*, Image_Data.FileName FROM Image_Data RIGHT JOIN TopRecord ON Image_Data.ImageID = TopRecord.ImageID;", connStr, 0, 1 ImageID should be what is sorted. Can someone help? Do you need to see more code?
View Replies !
Displaying DATE Of Text Format In Descending Order
Hi All, I have a field named "PICK_DATE" in text format where pickup date is stored in DD/MM/YYYY format. Now I wanted to generate a report with the order by clause of PICK_DATE. But it is not giving me the desired result. I want to see the latest PICK_DATE at the top of the report in desending order. Can any one pls help me out to solve this problem ? :confused: Thanks in advance, Jignesh
View Replies !
Sort Not Working (Ascending)
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 Replies !
Sort Query Ascending
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 Replies !
Access 2000 Ascending Sort
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 Replies !
Jumping Of Autonumber In A Non Ascending Order
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 Replies !
Random Query In Ascending Order
Hello, I hope I can expressed this clearly! I wanted to create a random sequence using query in ascending order by visitor.join and randomid and use it in the form that has a button that will run requery for a certain random number of times. Running the query will results to 2 names at the top of the list because of the priority in ascending and random order and followed by other names (which also in random order). I did not apply any filter. My problem is when I use the query in form names get filtered, only 2 names flashes randomly. Is there a way to flash all names in random but will only pick priority name in the end? I apprecicate any help. Below is the sql statement SELECT visitor.Name, visitor.Join, Rnd([id]) AS randomid FROM visitor ORDER BY visitor.Join, Rnd([id]); and button Private Sub Command1_Click() Dim ab As Integer ab = Int((1000 - 200 + 1) * Rnd + 100) Do While ab <= 1000 Requery ab = ab + 1 Loop End Sub Many thanks Ice2big
View Replies !
Howto Make Combobox Selections Appear In Ascending Order
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 Replies !
Problem With Sort Order
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 Replies !
Dynamic Sort Order
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 Replies !
Sort Order Problem
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 Replies !
Sort Order Question
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 Replies !
Dynamic Sort Order
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. While OrderItem consists of sequence numbers of the Item. The SQL query for the record source works but I can not enter any value from the form/front end. So, the idea of having a special table for sort order is not OK. Can anybody give me a clue for the solution?
View Replies !
Specific Sort Order
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 Replies !
Need Weird Sort Order
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 Replies !
|
TRACKER
