Populate Data in Calculated Field in an Access Database Table

0
votes

I have a table which contains:

CostValue | SpentDateFrom | SpentDateTo | Jan2019 | Feb2019 | Mar2019 till Dec2019

Now I would like to populate the costvalue based on spentdatefrom to spentdateTo.

For example: if the cost value is 2000 and the start date is Jan2019 to Feb2019 then the value of 2000 should be populated to Jan and Feb 2019 Field.

Any help would be appreciated, thanks.

1
databasems-access
Use an UPDATE query. However, what you show as table structure doesn't make sense. - June7
I will try it thank you! i know seems like that :) just trying something if its possibly useful. thanks again - Jhay16

1 Answers

0
votes

Use “Calculated Field” as field type for the CostValue field.