I'm trying to link two DBF files in Crystal but the problem is that in the Names DBF, the account number is 7 characters and in the Deposit DBF, the account number is 9 digits (an extra 2 digits added on the end). Without manually going into the table and removing the last 2 digits from every account number, how can I link these two tables? I've thought of going into Access and creating a new field in the table that is based on the original account number (minus the extra digits) but I'm not sure how to do that. Ideas?
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!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking Issue!?
- Thread starter Seabz420
- Start date
Create a formula field that takes the first digits:
Left({YourField},7)
The write a subreport and link the subreport on this formula field.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com
Left({YourField},7)
The write a subreport and link the subreport on this formula field.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question