Using criteria to update fields in a update query

[jagstangman]

Ok, i have a question about update queries.

I have two tables (I'll call table 1 and table two for simplicity) and an update query. I want to get some data from table one to table two (via an update query). But in table two there is a field that isn't in table one but i want to add a value to that field via the query.

My question is, can i manually put into the query what data to add to a field instead of/aswell as using data from other tables.

I hope you understood my questions.

Cheers

 

[Matt Greatorex]

To transfer data you need an append, rather than an update, query.
e.g.

INSERT INTO Available_Reports ( Listed_Name )
SELECT AllReports.Listed_Name
FROM AllReports
WHERE (((AllReports.Listed_Name)=[Enter Name:]));

This query just appends the values from one field of one table to one field of another, but you should get the idea.

The [Enter Name:] bit will prompt you to enter the criteria when the query is run.

Hope that makes sense?

 

[jagstangman]

Thanks for your help. It makes sense.And it now works.

I got confused with update and append for some reason although i've been using them in the past correctly. lol oh well, thanks for your help.

 

[Matt Greatorex]

Glad to help.