crosstab query report sort

S

Souris

I have a report using crosstab query.
The report automatically to sort alphabetical order by default.

for some reason, I need those information order as user enetred.

Are there any way to take out the auto sort alphabetical?


Your help is great appreciated,
 
D

Duane Hookom

Do you have anything stored anywhere that identifies the sort order?
Are you actually refering to the column order or the row order?
 
E

Evi

is it the column headers or is it the Row headers which you need to sort
differently?

I'm guessing that you are talking about the column headers. You can't sort
them non-alphabetically but you can replace the column heading with eg a
SortOrder number so that the user can specify what comes first, then you
could use a text box with a Dlookup in it for creating the visible column
headers in your report. So if your column headers currently contain
SalesPerson Name, you could use SalesPersonID as your column header.
Evi
 
S

Souris

Thnaks millions,

Evi said:
is it the column headers or is it the Row headers which you need to sort
differently?

I'm guessing that you are talking about the column headers. You can't sort
them non-alphabetically but you can replace the column heading with eg a
SortOrder number so that the user can specify what comes first, then you
could use a text box with a Dlookup in it for creating the visible column
headers in your report. So if your column headers currently contain
SalesPerson Name, you could use SalesPersonID as your column header.
Evi
 

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