Computer Learning Zone CLZ Access Excel Word Windows

Don't know if it's good or bad that a Google search on "Big Bang Theory" lists the sitcom before the origin of the Universe

-Neil deGrasse Tyson
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Access >

Back to TechHelp

More append tables Upload Images   Link  
William Kennedy 
2 months ago
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.
Kevin Robertson
2 months ago
Union Query

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to TechHelp
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn