I have an update query that needs to update data in JAN, FEB, MAR...fields in table A, based on the DATE field in linked table B.
I have the update set to:
JANBUD FEBBUD
IIF(Month([DATE_Field]=1,[BUDGET_AMOUNT],0) IIF(Month([DATE_Field]=2,[BUDGET_AMOUNT],0)
The problem I'm having is that it's only updating the last record, month 12, and nothing before that.
I have records with month numbers 1-12
I have attached the snapshot of the query.
Any help is much appreciated.
I have the update set to:
JANBUD FEBBUD
IIF(Month([DATE_Field]=1,[BUDGET_AMOUNT],0) IIF(Month([DATE_Field]=2,[BUDGET_AMOUNT],0)
The problem I'm having is that it's only updating the last record, month 12, and nothing before that.
I have records with month numbers 1-12
I have attached the snapshot of the query.
Any help is much appreciated.