JohnPeasley
Registered User.
- Local time
- Today, 00:33
- Joined
- Nov 28, 2016
- Messages
- 10
I have to create a string either in a query or on a form (which hopefully can update a query). There is one numeric constant (1234) and another figure that comes from the input spreadsheet (Office -WXYZ) and in between them three variables.
My big dilemma is that some branches have a “W” in the string, while others use an alpha designator based on the fiscal month to create an account number. I haven’t been able to figure out how to concatenate the data, when the Alpha is variable based on the office. I have a table that lists all the offices and could add a field for the alpha, but month to month how can I use the monthly alpha designator since that changes and a “W” for some branches, which does not change?
Bank - 1234 (Constant)
Branch Alpha - either a "W" or an alpha month identifier depends on Office
Year - 7 (Another variable currently using input spreadsheet)
Teller Initial - K in Example Below (Another variable currently using input spreadsheet)
Office - WXYZ (Spreadsheet)
Example
1234W7KWXYZ or 1234H7KWXYZ (H is month identifier for May)
My big dilemma is that some branches have a “W” in the string, while others use an alpha designator based on the fiscal month to create an account number. I haven’t been able to figure out how to concatenate the data, when the Alpha is variable based on the office. I have a table that lists all the offices and could add a field for the alpha, but month to month how can I use the monthly alpha designator since that changes and a “W” for some branches, which does not change?
Bank - 1234 (Constant)
Branch Alpha - either a "W" or an alpha month identifier depends on Office
Year - 7 (Another variable currently using input spreadsheet)
Teller Initial - K in Example Below (Another variable currently using input spreadsheet)
Office - WXYZ (Spreadsheet)
Example
1234W7KWXYZ or 1234H7KWXYZ (H is month identifier for May)
Last edited: