Append Query

[MdHaziq]

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

[Minty]

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.

[isladogs]

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

[MdHaziq]

Dear,
Minty

My intention was to move supplier information from tblMaster1 to tblSuppliers.

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.

I will try it out!

Thanks

Dear
ridders52


Sorry for being sloppy w/ my post.
I will certainly post only what is neccessary in the future.

Deepest appologies

Haziq

[SierraJuliet]

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;