Dear
Forum,
I would like to append records form tblMaster1 to tblSuppliers.
I run the query but it did not append my tblSuppliers.
Any reason why?
TIA
Haziq
Dear
Forum,
I would like to append records form tblMaster1 to tblSuppliers.
I run the query but it did not append my tblSuppliers.
Any reason why?
TIA
Haziq
That makes no sense - why would store all that data in master one and then in the Suppliers table as well.
If you as simply moving the data into the new table, then change the join to a right join and add criteria to the supplier ID of Is Null.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
If you want a reply you either need to remove the login form or tell us the user name and password.
Suggest you only post the relevant parts of your db
Dear,
Minty
My intention was to move supplier information from tblMaster1 to tblSuppliers.
I will try it out!moving the data into the new table, then change the join to a right join and add criteria to the supplier ID of Is Null.
Thanks
Dear
ridders52
Sorry for being sloppy w/ my post.
I will certainly post only what is neccessary in the future.
Deepest appologies
Haziq
Would a SELECT INTO work? Exclude the IN if not a separate db. Just execute the statement from where the data currently resides.
SELECT Column 1, Column 2, Column 3, etc
INTO tblNewTable IN NewDatabase.accdb
FROM tblOldTable
WHERE some condition;