Hi All, please could you assist
I have 2 tables , a master and a history tbl
I want to update a few fields in the history tbl from the master tbl
lets say i have 2 of the same records in the master tbl but the frequency is different. I have the same 2 records in the history file.
when I do a normal select query i get 4 record, when I change to update query, it updates to the same frequency and the other frequency has not been updated.
what am i doing wrong here? am i missing something?
Select query shows the correct records when i use the total (summary) button but on update query the total button is not available.
I have 2 tables , a master and a history tbl
I want to update a few fields in the history tbl from the master tbl
lets say i have 2 of the same records in the master tbl but the frequency is different. I have the same 2 records in the history file.
when I do a normal select query i get 4 record, when I change to update query, it updates to the same frequency and the other frequency has not been updated.
what am i doing wrong here? am i missing something?
Select query shows the correct records when i use the total (summary) button but on update query the total button is not available.