Access Remove Sort when Parameter 1

[snip6969]

Hello,

I have a query/report that require paramaters. The found data for the paramaters entered need to be printed in order of the parameter entry. Access keeps sorting these based on the parameter entry value. For example: The parameter is [Fruit1] or [Fruit2] or [Fruit3]. For [Fruit1] I want to enter Oranges, [Fruit2] I want to enter Apples, and [Fruit3] I want to enter Grapes. On the report I want it to print Oranges first Apples second, and then Grapes third. Access keeps sorting it Apple, Grapes, Oranges. Please help.

 

[fuseen]

Let's see your code for showing the parameters on that report...

 

[GoDawgs]

In the recordsource of the report, have actual columns for each of your parameters...in this case Fruit1, Fruit2, and Fruit3. Sort each of these columns ascending.

Kind of confusing...you'd still need to have each of your parameters in the criteria portion of whatever field you have them in, but also have them as extra columns. Hope that helps.

Kevin

 

[snip6969]

Kevin,

Thanks for the reply. Could you walk me through it? The field name is Fruit. How do I make a column for each of my parameters and then include those columns in my Fruit field criteria.

 

[snip6969]

I just tried doing the column thing and it works for the query, but its the report that keeps sorting it. Also note that I am using grouping on the Fruit name. If I don't group on the fruit name on the report it works fine. Is it possible to group on the fruit name but not sort it?

 

[GoDawgs]

I might have been drunk when I responded to you the first time because I don't think my solution works at all...or maybe I'm just forgetting how.

Anyway...for the report...

I don't know of a real easy way for this, but I might be forgetting something. This way will work though:

In your recordsource for the report add a new field called "SortOrder" and use this formula for the value of the field:

SortOrder: iif([FruitFieldName]=[fruit1],1,iif([FruitFieldName]=[fruit2],2,3))

Then in your report you would have a grouping for the SortOrder field before you have the grouping for Fruit Name.

Hope that helps more than my last post...

 

[snip6969]

GoDawgs your post was perfect! The report sorts correctly now. Good thinking!

 

[GoDawgs]

Glad to help...