Search results for query: *

Thank you very much for your help. The replace command worked!!! My problem was that there was an inconsistency in the way the data was entered. I thought ", PRN" had only been added to the {firstname.field}, turns out it had also been randomly added to the {lastname.field}. I had...

Thanks for your help. I must be doing something wrong becuase when I try the Replace command I get rid of all the first names and only "PRN" shows (which is the exact opposite of what I'm trying to do) and when I try the Left, Length command I get the message "string length is...

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...

Thank you very much for your help !!! That worked great.

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...

Thank you for your help, that worked.

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...

I have a not too dissimilar problem using dBase IV, but I don't get file open problems: instead I get index out of date. I would imagine that this is not down to a speed problem that can be solved with IDXFIX. Does anyone know of a tool that can be run from the command line that will create a...