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
Larry Linson - 25 Mar 2008 02:20 GMT
>I am running a report by entering parameter values, my problem is, that
>when
[quoted text clipped - 3 lines]
> the
> parameter values?
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
John Spencer - 25 Mar 2008 13:09 GMT
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

Signature
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.
>I am running a report by entering parameter values, my problem is, that
>when
[quoted text clipped - 7 lines]
>
> Thanks