Sorting fields in a record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl - 16 Apr 2006 00:23 GMT

These are a set of fields to store numeric data to be sorted.
eg.
Number1 6
Number2 8
Number3 16
Number4 3
Number5 7
Number6 25

result should be sorted from lowest to higest in the following fields, how
could this be done? Thanx a lot.

First = 3
Second = 6
Third = 7
Forth = 8
Fifth = 16
Sixth = 25

Reply to this Message

tina - 16 Apr 2006 00:33 GMT

your table is not normalized. the best you can do is to normalize the data
using a Union query, so that all the data is in a single "column", and then
sort the data in that column of the query. you can read up on Union queries
in Access Help. recommend you also read up on normalization principles, see
http://home.att.net/~california.db/tips.html#aTip1 for more information.

hth

> These are a set of fields to store numeric data to be sorted.
> eg.
[quoted text clipped - 14 lines]
> Fifth = 16
> Sixth = 25

Reply to this Message

Marshall Barton - 16 Apr 2006 00:52 GMT

>These are a set of fields to store numeric data to be sorted.
> eg.
[quoted text clipped - 14 lines]
> Fifth = 16
> Sixth = 25

While almost anything can be done with enough programming,
your request is not practical in a database.

A fundamental rule of relational databases is that related
values need to be in separate records (in a separate table),
not in fields in a single record. Records can be sorted
very easily, but it is near ridiculous to sort fields.

You can not apply the concepts of spreadsheets to database
tables. Search the web for an elementary explanation of the
first three rules of database normalization for more
information.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Carl - 16 Apr 2006 01:00 GMT

Thanks a lot

> >These are a set of fields to store numeric data to be sorted.
> > eg.
[quoted text clipped - 27 lines]
> first three rules of database normalization for more
> information.

Reply to this Message