Good day to everyone...I'm a newbie here and a novice in VB6 programming...
I really having a hard time formulating the correct syntax on how to merge multiple tables in Access 2003 using VB6. All the tables that I want to merge had the same fields.
For example Table1 includes these Fields: LineNumber,JobName,Batch,Coder,DocDate,DocChar
And the next table also have these fields:
LineNumber,JobName,Batch,Coder,DocDate,DocChar
Thanks guys...