B
Bill
I can filter and sort my customers on different routes and view them in a
data sheet form but can't seem to get them to sort the same way on a report.
On the report i want to print out the Order form for the same customer on
different days sorting them in different rotations per route. On the customer
table i have a field for each day [Monday] a field for a rep each day [Monday
Rep] and a field each day for the rotation of servicing [Monday Sort]. So i
query the day and the rep but have trouble sorting it by the day without
going in and manually choosing ascending on the sort field of my choice. i
have it menu driven.
data sheet form but can't seem to get them to sort the same way on a report.
On the report i want to print out the Order form for the same customer on
different days sorting them in different rotations per route. On the customer
table i have a field for each day [Monday] a field for a rep each day [Monday
Rep] and a field each day for the rotation of servicing [Monday Sort]. So i
query the day and the rep but have trouble sorting it by the day without
going in and manually choosing ascending on the sort field of my choice. i
have it menu driven.