Append Query Does Not Work

access2010

Registered User.
Local time
Yesterday, 20:58
Joined
Dec 26, 2009
Messages
1,115
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
 

Attachments

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.

attachment.php
 

Attachments

  • Screen Shot.jpg
    Screen Shot.jpg
    73.3 KB · Views: 419
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.
 
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
 
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
 
It is not an append query you've to use, but an update query.
 

Users who are viewing this thread

Back
Top Bottom