I have three Similar Tables in structure. Same Field Names and Structure. They are individual Banking accounts and each of their queries generate Reports that have running Balance. This is used to validate each individual Bank Account per statement.
I want to combine all three tables, sort by date, make a combined table with new Auto number Primary Keys. That table will be used to generate a report with all common fields plus a field Identifying the bank account with a running daily balance.
Ive been trying to get this to work last couple weeks. I would like to put all these actions into a Button. I think the sequence needs to be:
Delete the old Combined Table.
Append the three different Bank Account tables into the combined table.
Sort final Combined table by date.
Need to make Table IDs sequential by date so the running Balance works.
I think I can generate a second unique ID by converting the Date field to Number format YYYYMMDD and adding the Primary Key ID number to make sure the Second Unique ID with the same date fields will not be the same. I need this second ID field to generate the running balance for the combine table fields.
Generate Query for running Balance of Combined table.
Then I can use the Query later in a Multi field Search form.