Solved: Simple Append Query

[akn112]

Now im exploring the append query realm and i cant even get a simple one to work. I've tried making an append query to take a column of fields in "test" and append it to "table1" there is a relating field called ecode which is in both tables. when i try to append it, the table just creates blank entries?? anyways, try it out and you'll see. I think this is just me being stupid and i missed something?:banghead:

[akn112]

newb question...nm lolz

[Norie]

Why do you even want an append query?

An append query, well, appends data to a table.

It seems to me that what you really want is an un update query.

And I'm still not sure if you need that anyway.

[akn112]

haha your right norie. i wanted an update query. havent really played with all the types of queries yet. I found out my stupid mistake though lolz