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 bkrike 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: *

  • Users: richardm
  • Content: Threads
  • Order by date
  1. richardm

    How to truncate last 5 characters in a field ?

    Hello everyone! What is the formula or command to truncate the last 5 characters of a field. In the database I'm using the person doing data entry added ", PRN" to the end of a persons first name. Many of the first names look like: Thomas, PRN John, PRN Suzy, PRN Lisa, PRN What...
  2. richardm

    Grouping by specific segment of field (first 4 numbers out of 8)

    Hello everyone! I need to create a report in which I group by 1st and 2nd segment of my GL #'s. My general ledger is broken up as follows 4000-1-022 where the first 4 #'s represent my general ledger account break (i.e. revenues, expenses, etc.) the 5th number represents department and the last...
  3. richardm

    Grouping by specific date range

    I'm trying to group by year, my formula reads If {date.field} > Date (1998,01,01) and {date.field} < Date (1998,12,31) then {date.field} The report returns everything in the range, however when adding other fields like {customer.name} and {invoice.amount} it suppresses, does not print...

Part and Inventory Search

Back
Top