Add field from query to table

[Golfinray]

I have a table named 06-07 Tracking. I have a field I need to add to that
table called Date Plans Received in a query called Agreement Received. I have
project number in the table and in the query, and of course I would like for
the Date Plans Received data to go with its associated project number. There
are also nulls in the Date Plans Received field. I tried writing an update
query in sql and never got the syntax right. I also tried an update query and
never got that right either. Help! Thanks, a bunch!!!!!

 

[Lord Kelvan]

well first have you actually created the field in the table if not
then go an modify the table to have the new field date_plans_recieved
then you can do your query

update [06-07 tracking],[Agreement Received]
set [06-07 tracking].[date_plans_recieved]
where [06-07 tracking].[project number] = [Agreement Received].
[project number]

and that should do it

regards
Kelvan

 

[Jeff Boyce]

If you have a 'table named 06-07 Tracking', you may be confusing Access with
Excel. In Excel you'd probably use a different sheet for each year's data,
but in a relational database, embedding data in the tablename is a no-no.
Yes, you can do it, but you will make much more work for yourself and for
Access if you do.

Consider posting a description of the table structure and data elements you
now have. Folks here will be better able to offer suggestions for how you
can get better (and easier) use of Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP