Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

sorting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hans90 - 24 Mar 2008 14:26 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.