sorting

  • Thread starter Thread starter hans90
  • Start date Start date
H

hans90

I am running a report by entering parameter values, my problem is, that when
the report is generated it automaticaly sorts these numbers numericaly. Is
there some way to have the report generated in the exact orededr I enter the
parameter values?

Any help would be appreciated.

Thanks
 
hans90 said:
I am running a report by entering parameter values, my problem is, that
when
the report is generated it automaticaly sorts these numbers numericaly.
Is
there some way to have the report generated in the exact orededr I enter
the
parameter values?
Click to expand...

I don't know how you are "entering parameters" for your question to have
meaning -- if you are using parameters on a Query used as RecordSource for a
Report, they will be requested in the same set order each time you execute;
if you are using a Form, you'll have Text, List, or Combo Boxes, and you'd
have to jump through hoops to determine the order in which those were
entered, and even more hoops to reorder the Report. Please clarify -- if we
can understand the question, someone will usually have a good suggestion.

I recommend you use a Form with TextBoxes for entering the Values, and do
not use Parameters in a Query that is RecordSource. You choose the data
which will be used to order the report in the Report's Sorting and Grouping
property.

Larry Linson
Microsoft Office Access MVP
 
The only way I can think of to do this is to use a separate table to hold
the criteria and to hold a sequence number.

SELECT T.*, CriteriaTable.Sequence
FROM YourTable as T , CriteriiaTable
WHERE T.SomeField = CriteriaTable.Criteria
ORDER BY CriteriaTable.Sequence

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top