Hi, I am just trying out something here. Although I have gone thru various post concerning this question, but I haven't seen the exact one that fits into my criteria.
I want RecordSet that Insert The Following Fields from a query (MyQuery) into a new table (MyTable)
MyQuery feilds are TransID, CriteriaID, Date, Description, Qty, Amout (CriteriaID = Forms!MyForm!CriteriaID)
and
MyTable feilds are TransNo, CriteriaID, Date, Desc, Qty, Amount
Thanks and compliments
Moore
I want RecordSet that Insert The Following Fields from a query (MyQuery) into a new table (MyTable)
MyQuery feilds are TransID, CriteriaID, Date, Description, Qty, Amout (CriteriaID = Forms!MyForm!CriteriaID)
and
MyTable feilds are TransNo, CriteriaID, Date, Desc, Qty, Amount
Thanks and compliments
Moore