Append Query Does Not Work

[access2010]

Hello

Could you please advise me as to what we have done wrong as this Append Query does not work in our Ms Access 2003 Database

Thank you

Nicole

 

[sneuberg]

It seems to be working fine on my system but I wonder if you really want what it is doing. It is appending from the Investments01_tbl table back to the Investments01_tbl table for the criteria specified.

 

[pbaldy]

Define "doesn't work". It adds records to the table for me. The data doesn't make much sense to me though, so I'm not sure what it should do.

 

[access2010]

Thank you for your note

Do you suggest that we make a copy of our source table with the two field and than run the append query from the copy table to our real table

Thanks

Nicole

 

[sneuberg]

Do you suggest that we make a copy of our source table with the two field and than run the append query from the copy table to our real table

No, why would anyone suggest that?

 

[access2010]

Thank you for your note

Please advise how we can have the word "Income" placed into the field "Return_1"

If the transaction type = Dividend, how can we have the word = Interest inserted into the field = Return_1

Your suggestion will be appreciated, as we are all volunteers at this local charity and not programmers

Martha

 

[JHB]

It is not an append query you've to use, but an update query.

 

[access2010]

Thank you for your assistance

Nicole