date parameter query: sorting question

[maacky99]

I have a query that has date parameters, so I see the info I need for the set time period. Once the query is open (in datasheet view) I am prompted to enter the time period every time I want to sort any field (i.e job number, quoted price, etc). Is that normal or is there a way around that? I like to see my queries a lot of different ways to examine the data.

Here is what I have in the criteria for the date field: >=[Beginning Date?] And <=[Ending Date?]

 

[Rich]

You should create a form with two unbound textboxes to pass the parameters to the query, just keep it open while viewing the query.
Your criteria then becomes
Between Forms!YourForm!StartDate And Forms!YourForm!EndDate

where Start and End date are the names of your text boxes