Sort on a field in a report

[gehrenfeld]

Below is a screen shot of my report.

I would like to be able to click on one the fields then have the report sort on that field then redisplay the report with that sort.
Hope that makes sense.

[ranman256]

reports dont work that way.
use a query.

[gehrenfeld]

Queries look bad and don't format the way Reports do. Was just wondering if there was a way.

[June7]

That should be possible with report in ReportView, not PrintPreview. Would need code in each textbox Click event. Example:

Private Sub Zip_Click()
Me.OrderBy = "Zip"
Me.OrderByOn = True
End Sub