Input data removes sort order 1

[hjgoldstein]

Hi guys.

I am probably going to get told off for this but here goes.

I need to produce a report within a date range to be input by the user.

I have set up the query with "Between [Enter Start Date] and [Enter End Date]" in the criteria for the "DecisionDate" field.

Also, the query is sorted by "Introducer" and "DecisionDate" fields, and when I run the query, all appears as required.

I have made a report based on the query, and it looks good, if I do say so myself.

I want to print the start and end dates on the report header, so have put two unbound controls "[Enter Start Date]" and [Enter End Date] in the header.

Now the problem...The dates appear in the header, but the sorting don't work no more.

Any idea how to achieve the dates on the header without losing the sorting?

Any help much appreciated.

Howard.

 

[dhookom]

First, IMO parameter prompts are never acceptable user interface faq701-6763. Consider using controls on forms.

Reports have a Grouping and Sorting Dialog in design view. This is the only reliable method for setting sort order in a report.

Duane
Hook'D on Access
MS Access MVP

 

[hjgoldstein]

Thanks, Duane.

You are right as usual. I'll work on it.

 

[hjgoldstein]

Duane,

I have now had time to do what you suggested and it works like a charm.

Thanks again.

Howard.