Handling a yearly Index change calculation field?

[vdzr]

I was thinking to make a table with dates and indexes filtered for each client(record)
The calculated field must look for the last index (start)date before the pc 'now()' date (so you change pc date to see the previous year calculations)

query out the right indexes & date was ok but can I do this with code behind the formcalcultion field? Amount * top index from the query (but in code)

query :SELECT TOP 1 TblWoningverzFaktoren.secIDClient, TblWoningverzFaktoren.Aanvangsdatum, TblWoningverzFaktoren.IndexvanPremiewoningverz, TblWoningverzFaktoren.FaktorvanPremiewoningverz, TblWoningverzFaktoren.IndexvanPremieInhoudVerz, TblWoningverzFaktoren.FaktorvanPremieInhoudVerz, TblWoningverzFaktoren.IndexvanPremieValuables, TblWoningverzFaktoren.FaktorvanPremieValuables, TblWoningverzFaktoren.IndexvanPremieLiability, TblWoningverzFaktoren.FaktorvanPremieLiability, TblWoningverzFaktoren.IndexvanTotPremie, TblWoningverzFaktoren.FaktorvanTotPremie
FROM TblWoningverzFaktoren
WHERE (((TblWoningverzFaktoren.secIDClient)="C2700") AND ((TblWoningverzFaktoren.Aanvangsdatum)<Now()))
ORDER BY TblWoningverzFaktoren.secIDClient, TblWoningverzFaktoren.Aanvangsdatum DESC;

 

[ProgramError]

so you change pc date to see the previous year calculations

This will cause complications later. How about using a popup box to enter the date.

Ian Mayor (UK)
Program Error
Your lack of planning is not my emergency!

 

[vdzr]

How does it go?

I made already a tabform where you can see the date with the different indexes and factors.

clients have different indexes and each year has different indexes.
Each client has about 15 subrecords within each record 4 calculated fields based on the index before a (input)date.

 

[vdzr]

In what way there will be complications?