Sort Order

[sam]

I have a report which lists peoples names and various corresponding values
beside each one. Each person receives a report and I would like to be able to
choose who I am printing the report for (which I can do) and have their name
appear first (at the top) of the list, this part I cant do. I can't think of
any way to do this, can any one assist?
Thanks

 

[Ken Snell \(MVP\)]

Add a calculated field to the query that provides data to the report. This
calculated field should be something like this:

PersonSort: Forms!FormName!TextBoxName = [PersonNameField]

The assumption is that you have a form that you use to select the person for
whom the report is being run, and that form has a textbox on it that
contains that person's "ID" value from the table.

Then, in the report's Sorting & Grouping window, put PersonSort as the first
field being sorted (ascending order).

 

[sam]

Perfect, Thank you.
--
Thanks

Add a calculated field to the query that provides data to the report. This
calculated field should be something like this:

PersonSort: Forms!FormName!TextBoxName = [PersonNameField]

The assumption is that you have a form that you use to select the person for
whom the report is being run, and that form has a textbox on it that
contains that person's "ID" value from the table.

Then, in the report's Sorting & Grouping window, put PersonSort as the first
field being sorted (ascending order).

--

Ken Snell
<MS ACCESS MVP>

I have a report which lists peoples names and various corresponding values
beside each one. Each person receives a report and I would like to be able
to
choose who I am printing the report for (which I can do) and have their
name
appear first (at the top) of the list, this part I cant do. I can't think
of
any way to do this, can any one assist?
Thanks