Sorting a look up table for a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone, need some help, I have used a look up table for a list of value,
but I now need them to be sorted in a specific order for a report. to give
you an Idea of my problem here is the data in my lookup field

" ","Lt Col","Maj","A/Capt","Capt","A/Lt",'Lt","A/WO1","WO1","A/WO2" is goes
on a bit further but you notice that I have a lot of A/ in this lookup field.
Is there anyway to ensure that when it sorts it it comes out in the Order
that I have put it in, in the lookup table
 
In your lookup table you should add a sort field so you can specify the sort
order.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Thank you very much but there is not sort option within the lookup or am I
being a complete numpty
 
Plus if I add a sort into this it would bring it up alphabetical and not in
the order of input, which is the goal.
 
Hi

To follow on from Bob's answer

Add a new field to the table (number format). In this new field put the
"level" of the rank.
Lt Co, 1
Maj, 2
A/Capt, 3
Capt, 4
A/Lt, 5
Lt, 5
A/WO1, 6
WO1, 7
A/WO2, 8
etc
etc
(oh, those numbers may be wrong you will need to put the right ones in)

The source for your list would be something like this

SELECT [TableName].[Rank], [TableName].[Level] FROM [TableName] ORDER BY
[Level];

Hope this helps
 
Thanks Wayne - that's exactly what I was attempting to get at (although I
didn't do a great job of it).
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.


Wayne-I-M said:
Hi

To follow on from Bob's answer

Add a new field to the table (number format). In this new field put the
"level" of the rank.
Lt Co, 1
Maj, 2
A/Capt, 3
Capt, 4
A/Lt, 5
Lt, 5
A/WO1, 6
WO1, 7
A/WO2, 8
etc
etc
(oh, those numbers may be wrong you will need to put the right ones in)

The source for your list would be something like this

SELECT [TableName].[Rank], [TableName].[Level] FROM [TableName] ORDER BY
[Level];

Hope this helps

--
Wayne
Manchester, England.



Jessybloke said:
Thank you very much but there is not sort option within the lookup or am I
being a complete numpty
Click to expand...
Click to expand...
 
Back
Top