text & numbers

D

David Rogers

HiYa, your guidance would be appreciated

I am listing Karaoke discs numbering SF 155 (- 1), SF155 (- 2), through to
SF 155 (- 15) etc. Is there any way I can list via a Query where (- 2) will
follow (- 1) without putting the last digit in brackets?

thankyou
 
J

John Vinson

HiYa, your guidance would be appreciated

I am listing Karaoke discs numbering SF 155 (- 1), SF155 (- 2), through to
SF 155 (- 15) etc. Is there any way I can list via a Query where (- 2) will
follow (- 1) without putting the last digit in brackets?

thankyou
Click to expand...

Sounds like you're trying to pack multiple pieces of information into
one field. Don't! If SF155 identifies one thing, related one-to-many
to a sequential number, use TWO FIELDS for your key: one containing
SF155, and the other (an integer field) for the 1, 2, 3 etc. You can
then sort by the two fields, and concatenate them for display purposes
with an expression like

FirstField & " (-" & SecondField & ")"

John W. Vinson[MVP]
 
Top