Report with date select/search and other variables

[peter2012]

I have a report reporting events that occurred today, using =Date() in the query.

I want to have a control/box on the report which shows today's date by default, but enables me to select a different date with the outcome that the report refreshes and shows the events on the selected date instead.

Maybe I need a form for this although I would like to do conditional formatting so a report is better.

Can anyone give me clues as to how to do this.

It would also be good to be able to sort by column values, as in a table on a webpage with sort controls in the column headings which work just by clicking.

Again any clues as to how to do this would be welcome (the simpler the better!).

Thanks

Peter

 

[JHB]

Reports is normally used for printing out on paper.
The most of your requirements is better done in a form, so if you don't need to write it out, use a form instead. You can also use conditional formatting in forms.

 

[peter2012]

Ah, conditional formatting of forms, didn't know that. Thanks.

So I'll use a form. Any ideas anyone how I proceed from there?

Peter