Sort of Concatenated Field


D

Don

I'm a hobbiest using Access to save my First Day Cover collection in a
data base. Nearly 10,000 items so far. The key to the collection is
the "Scott Number", which I set up as a concatenation of three fields:
Prefix as text, Number as number and Suffix as text. I want to sort on
the Number field first when the Prefix is Null, next on the Prefix
field. The underlying query sorts as desired. I've juggled the sort
fields in the query and report but can't get the desired report
output. Got code?
Thanks, Don
 
Ad

Advertisements

M

[MVP]

I'm a hobbiest using Access to save my First Day Cover collection in a
data base. Nearly 10,000 items so far. The key to the collection is
the "Scott Number", which I set up as a concatenation of three fields:
Prefix as text, Number as number and Suffix as text. I want to sort on
the Number field first when the Prefix is Null, next on the Prefix
field. The underlying query sorts as desired. I've juggled the sort
fields in the query and report but can't get the desired report
output. Got code?
Thanks, Don

Hi Don,

Use report Sorting & Grouping to declare field for which you want to
sort data; in this case that will be "Scott Number".

Regards,
Branislav Mihaljev
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top