473,395 Members | 1,702 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

I need the data to be displayed in the table without sorting

I'm working with database in access 2003, In the table, it arranges the data automaticaly on alphabetic order.
My referance nos like this
PCW/AF/001
PCW/SF/002
PCW/AF/003

I want the date to be sorted to 001, 002, 003
The problem is, automaticly arranges data based on AF/SF
Please help me
Nov 8 '10 #1
1 1571
Stewart Ross
2,545 Expert Mod 2GB
Create a query based on the table. Add a computed field to that query like this:

NumericPart: Right([name of the field concerned], 3)

(Obviously, use the real name of the field in place of the one called [name of the field concerned] above.)

Sort the query on the computed field.

-Stewart
Nov 8 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Hunter Hou | last post by:
Folks, I am just curious why standard library doesn't provide a "merge" operation without sorting, because sometimes I don't require sorting, just merge. I looked at list.merge() and merge()...
2
by: efiryago | last post by:
Is there a way to calculate size of a table without runnig statistics to use NPAGES info. In my case there are a few very large tables in the same tablespace with very outdated stats, so LIST...
2
by: ¹ùÑÇ·æ | last post by:
first of all ,i will thank you for reading this . :-) i am writing a programming to access SQL-SERVER. i use some codes as follows in order to update data changed in datagrid1. but i found that...
8
by: '69 Camaro | last post by:
Perhaps I'm Googling for the wrong terms. Does anyone have links to examples of the syntax necessary to read the HTML on another Web page when that HTML is produced from JavaScript using the...
1
by: Dino Buljubasic | last post by:
Hi, I am using VS2005 (C#) and SQL Server 2000. How can I make sure that: 1. Client A queries info from database and displays it in a list view or other controls on a form. If Client B...
2
by: rinmanb70 | last post by:
I have a table that contains transaction info including the date of the trans and the date of the order. Some orders do not have a transaction date yet. I'd like to have a report that shows two...
3
by: jmDesktop | last post by:
Hi, probably a simple question that I have for what I think is a simple database. I have a Vendors table and an Items table. There is only one items, but several Vendors may have that same item. ...
8
by: Killer42 | last post by:
Hi all. Is there any way to create a JOIN without sorting on the joined field? I'm sure I have asked something similar before, but can't seem to find it by searching TSDN. I have a big table,...
3
by: viratkothari | last post by:
Public Function MaxValOfIntArray(ByRef TheArray As Variant) As Integer 'This function gives max value of int array without sorting an array Dim i As Integer Dim MaxIntegersIndex As Integer...
1
by: servantofone | last post by:
I'm running Access 2003 on XP. I have a report that needs to be grouped by a field that contains values such as: Cherry Apple Grape I need to group my report by this field, but I am...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.