Update Query

Hi All,

Im a newbie - and have next to no knowledge of SQL or VBA - so i would appreciate it if any answers would state everything in idiot proof simplicity!.

And heres the issue:-

I wish to run an update query that will ask for a parameter initially then send the results to a new table-then automatically email itself on to the customer.

Or in other words....

So I need to query table A(with a paramater) then send the result to table B -Then email that on to my specified recipitent.

I can run parameter led queries easily enough -but update queries just wont produce the results in table B.

As i hope to become more advanced i would like to learnd VBA and SQL - which would be the best to start with?

For First part update query try this

UPDATE B.Field1 INNER JOIN A ON B.MatchingFieldname = A.MatchingFieldname SET B.Field1 = A![Field1], B.Field2 = A![Field2]
WHERE ((A.ParameterFieldname)=[Parametervalue])