Sorting A Field In Certain Way Which Is Neither Ascending Nor Descending

Jan 25, 2015

I have this form for data entry. I want to sort a field in a certain way which is neither ascending nor descending. The items in this field should be ordered as say, C, A, D, B. What I want is a custom order. How can we do it?

The field I am referring to is not on this form, but in the underlying table.

I am thinking of a VB code to achieve this purpose, where I can define the order. But not sure how to do it.

View Replies

How To Use One Button For Sorting In Ascending And Descending

Feb 28, 2013

I would like to do sorting by using one Button like (Toggle Button).In the first click the below code is work good for Descending but in the second click the code doesn't work for Ascending!!

Code:

Private Sub TabItemName_Label_Click()
If [TabItemName_Label] = -1 Then
Me.OrderBy = TabItemName & " DESC"
Me.OrderByOn = True

[code]...

View 7 Replies View Related

Ascending E Descending Order Of A Table.

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

Ascending / Descending From A Command Button

Sep 17, 2005

Using a command button what code would be required to get the records on a continuous form to ascend or descend

Jabez

View 4 Replies View Related

Modules & VBA :: Sort Ascending And Descending And Filter Continuous Form

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

Find And Replace Search Giving Either Ascending Or Descending Results

Dec 21, 2014

I have a DB and I have a button that triggers the find and replace. this will search over 100K entries and filter a specific client. The clients record can be 100's of entries.

This all works fine, but its always ascending and I have to scroll to the bottom for the latest record.

I can't set it to show Descending permanently as some employees can't cope with change. so...

I have a checkbox on my form for either Ascending or descending results. Is there any way I can get the find / replace to reference it, Or can I re-sort them after the search.

I've tried putting re-sort code on the 'find' button as lostfocus and mouseup but it doesn't work.

View 6 Replies View Related

Duplicate A Form And Sort A Form In Ascending Or Descending Order?

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

Sorting A Subform With Ascending Values

Nov 23, 2006

Hi All hope some one can help with this.

I have a sub for which is set to sort by ascending order for a given field which happens to be a text field with vales set something like abc1.1,abc1.2 ect. The problem is, is that when you get to abc1.10, and more these are then sorted as so
abc1.1
abc1.10
abc1.11
abc1.2
abc1.3
ect

How can I stop this and sort it:
abc1.1
abc1.2
abc1.3
.......
abc1.10
abc1.11

Thanks for any help with this
Paul

View 2 Replies View Related

Forms :: Comments In Descending Order In Memo Field

May 5, 2015

Having some trouble with a memo field. For each record, the notes field is present on the Form.... I added an unbound text box (txtMemoAdd) and a command button (Add New Note). When the button is selected, it adds the note to the Read Only Notes Field and adds a timestamp using the following code:

Me.Notes = Me.Notes & vbCrLf & Now () & VbCrLf & Me.txtMemoAdd
Me.txtMemoAdd = ""

The note is added to the bottom, and I was wondering if there was a way to make the new note go to the TOP of the field (Descending Order rather than Ascending).

View 5 Replies View Related

Form Based On Ascending Order Of A Field

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

Exporting Data In Excel Where Date Field Is In Ascending Order

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

Help Sort Descending Asp/access

Nov 10, 2006

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 3 Replies View Related

Reports And Field Sorting

Mar 10, 2005

I have a report that has a field (4) whose data is in the form of NO.1.1.2, NO.2.1.1, NO.1.12.3, etc. It is not allowing me to have the report display with those in order, sorting this field is not offered. My report is being grouped by Fields 1, 2, and 3, no sorting. How can the data then displayed in Field 4 be in order of those numbers. Sorry I don't know more about Access and I'm having to do this without support. Thank you

View 3 Replies View Related

Sorting A Date Field

Jul 4, 2005

i have a date field where about 80% of the data is entered in the format dd/mm/yyyy but the rest may be year only since the exact date is not known. Therefore, it does not have an input mask or a format set. Is it still possible to sort on that field? (As i write this i realise it is probably a dumb question but always worth a shot!)

View 3 Replies View Related

Sorting Field In Table?

Oct 24, 2012

I have a table that i would like to sort the records in one field Ascending.

I would like for the field to be updated after the record is entered so that the records in the field are all ways in a alphanumerical order.

I have put [SSB-CW].Square in the Order BY properties of the table. The Table is called SSB-CW and the field to sort is called Square. As i enter the records they stay in the order entered. When the table has been closed and then re-opened the records are sorted.

Do i need to design a form and set the lost focus property with the SQL [SSB-CW].Square.

View 3 Replies View Related

Displaying DATE Of Text Format In Descending Order

Jul 4, 2005

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 3 Replies View Related

Queries :: How To Sort Records By Grand Total Descending

Aug 9, 2013

I've recently been building a database on Access to replace the rather clunky and slow one we currently use here (built in Excel).Generally, I've been making it up as I go along which has worked quite well for me so far. However, I've encountered pivot tables. Normally, it shouldn't be a problem; the tables themselves are easy enough to understand. However, I've found that the tables aren't nearly as flexible as I would have liked. At least, not in a way directly apparent to myself.

(After trying, and failing, to include links to Imgur with details on my issue, I have included a .zip file with both images I was going to show)Generally, in Excel, the table works everything out for us, then we sort by largest to smallest and work out the totals for the last 7 days and the last 7-14 days (the week before last). After that, the last formula works out a percentage (loss or gain). [excel.png]

In the access table, though, I can't find a way to make this happen. There's no readily apparent button to add a new calculation field. I've tried using the create calculated total button, but that seems intent on making a separate total for each day on the table, which I don't want. [access.png]

Also, I can't figure out how to sort the records by grand total descending. I would have thought right clicking the grand total and clicking sort descending would have done it, but apparently that would be far too easy. I feel that it's prudent to mention that I'm not all that experienced with Access. I completed MOS and ECDL courses when I was in primary school, but it's been a really long time since that and all of the Office applications have changed rather dramatically.

View 1 Replies View Related

Sorting An Alphanumeric Text Field

Sep 30, 2005

I have a text field in a table that contains an alphanumeric code. i.e.

DEL998
DEL999
DEL1000
DEL1001
SUN998
SUN999
SUN1000
SUN1001
SUN1002
etc.

I want to run a query to find the highest number for a particular alpha code. In the example for DEL I would want the query to return DEL1001.

I have created a select query that asks for the alpha code, selects all codes starting with that code, sorts them in decending order and only displays the first record.

The problem is that because the field is a text field the numeric is not sorted like a number. So in the DEL case the query returns DEL999.

Any ideas on how I can get a result of DEL1001??

Thanks for your help

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

Sorting Form By A Field Value In A Table

Sep 4, 2014

View 1 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

Tables :: Sorting Table Field With Lookup

Aug 12, 2015

I have created a lookup in a field in a table:

select id, bike from tblbikes.
Column count 2
Width 0,3

When I try to sort the table by bike:

I receive the following error: Type mismatch in expression.

Is there some way to sort a field with a lookup.

View 3 Replies View Related

Queries :: Sorting Date From DateTime Field

Jan 27, 2015

I have a field on a table that is a DateTime format and it needs to be that way. I am trying to query that table for all the dates to use in a combobox but I only wat the date not the time. The problem is when I format the field to just date I can't sort it anymore as a date and I can't group them. I still get multiple lines in my combobox because there multiple times for the same day. what is the proper way in a query to extract just the date from a field and still sort it as date ie 1/12/2015 is greater than 12/15/2014?

View 8 Replies View Related

Forms :: Sorting (DATE) Field In A Subform?

Feb 21, 2014

I have a subform which tracks all the notes our personnel have entered in a specific project (which is the main form).

The issue is that I want the most current note to show in the subform when the project is "opened up". The underlying query for the subform has the [DATE] field sorted on "Descending".

View 2 Replies View Related

Purchase Orders And Lines - How To Make The Sorting Of 1 Field Dependent Upon Another

Dec 12, 2006

I have a database of purchase orders
Many of the purchase orders have a revision No against them, eg:-

Purchase Order No / Line No / Revision No / Value
1001 / 001 / 00 / £50
1001 / 001 / 01 / £100
1001 / 001 / 02 / £200

I am trying to find a way to write a query that will show me the actual value of the final revised value of each Purchase order line ie: the answer to above is

1001 / 001 / 02 / £200

Could anyone please help?

View 2 Replies View Related

General :: Sorting Recordset In Form - Add Numerical Field With Sequential Value

May 23, 2013

I've been building a small app for some friends. At present, they enter "records" line by line into a word processor, then use (archaic, IMHO) macros to produce the desired printouts. They wanted the new data entry UI to mimic that process.

Ok, so I've adopted the datasheet form as the principal entry vehicle. Based on the initial info they gave me, there were two convenient fields to sort on, so I used them in the OrderBy clause of the query which serves as the form's recordsource. I also developed the code to maintain the sort order after they inserted or deleted a record.

Now it turns out they don't require an entry into those fields, and in fact there's no logical field at all on which to order by.

So the question is: how to approach this? From my reading, I can't use the primary key or an autonumbered field, since the former won't necessarily reflect the desired incrementation and the latter only triggers for a new record, not an insertion (is this correct?).

My thought is to add a simple numerical field (which will be hidden from the user) with sequential values. I can do the OrderBy on it, and add code to adjust those values whenever a record is deleted or inserted. (That will require looping through the recordset from the point where the deletion or insertion occurred.)

For instance, is there some way to add a calculated field to the recordsource for this purpose?

View 11 Replies View Related