Hi,
I am really struggling here and need a quick reply.
I have two tables that i need to match a record from one with another by a fiew fields. I then need to store the results in another table and use the system clock to store in one of these fields.
I dont know how to store the results in a new table

Use either a maketable query if you are going to overwrite the previous results or an append query of you are going to add the results to an existing table.

HTH