Ordering Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is broken up into phase 1-5. A user wants to have the
ability to move a record up or down within a phase to signify its importance.
Is the any way to make a button maybe that move the record next to it above
the preceding record. Thank you for any help or ideas i have hit a wall.
 
Not easily.

You would need to add a field to your table (maybe call it "SortOrder"?) and
then assign a value to it that can be used by your reports. You would then
have to write code or maintain the field manually to manipulate your sort.

I had to do this in a database of mine to get certain bundle discounts to
appear near the products they apply to on an invoice.
 
OK I see how to set this up if the sort order is based on an item in the
Detail section but how do i set up a sort on an item in the header? From the
wizard it only allows me to sort by items in the detail section.
 
Huh?


--
Rick B



Edward Jones (Eddie) said:
OK I see how to set this up if the sort order is based on an item in the
Detail section but how do i set up a sort on an item in the header? From the
wizard it only allows me to sort by items in the detail section.
Click to expand...
 
The report is based on three linked tables. When i go through the wizard it
only allows me to sort based on the fields from the third table. Fields from
the first two tables are used as groups. I want to sort from a field in the
second group. Hope that clarifies a little can't seem to get it into words
too well.
 
I am not sure about the wizard. Build the report (use the wizard if you
want) then open it in design view and fix your sort using the Sorting and
Grouping box.

You would need to tell me the structure and all fields used and your desired
sort if you need a more detailed answer.
 
Back
Top