I have main table with 2-field primary key (ID and Programme).

I'd like to use update query to update 3 fields from other table. These 3 fields will be changing once a while.

I created Update Query per Access Help however it doesn't update anything.

Any help?

Cheers

more information needed.

50 columns in main table, 2 of them are primary key with duplicates ok index (ID and Programme).

Now I have other table that shares 3 columns with main table. I want to upload data from other table to main one for those 3 columns.

How to do that? Is update query good for this job?

honestly,

this setup sounds like something you should be doing in excel rather than access, and that's all I will say. Sorry to say that, but the information is very vague here, and there is no database to look at. perhaps uploading one will get you more response...