Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoeWharton

    Sort Sequence for Reports

    Duane, When I tried your suggestion and attempted to view the report a box popped up with the message 'Enter parameter value'. Something still seems to be wrong. Joe Wharton
  2. JoeWharton

    Sort Sequence for Reports

    Duane, Thanks for the help - I got that working ok. Now I need to know how to write a statement to put in the Sorting and Grouping box that will force a new group and skip to a new page when the leftmost character of a field changes. I tried the following and it didn't work: left(myfield),1)...
  3. JoeWharton

    Sort Sequence for Reports

    Duane, It hadn’t occurred to me to do two sorts. I’m not a very experienced user so I hope I can figure out how to implement your suggestion. One other question – In order to avoid the work of creating another field and entering a character in all the entries I want sorted to the end, would...
  4. JoeWharton

    Sort Sequence for Reports

    Duane, Thanks for the reply. Unfortunately, this database is one I converted from FoxPro and the two tables involved are fairly large, so I would have to remove several hundred entries (the ones I want to sort to the end of the report) from the existing field and put them in a new field. It...
  5. JoeWharton

    Sort Sequence for Reports

    This question regarding Access 2002 running under Windows XP. I would like to force certain entries in an Access table to the end of the table when the table is sorted or used in printed reports. In FoxPro I did this by inserting 'Alt 0160' as the first character of the entry I wanted to force...

Part and Inventory Search

Back
Top