Morning All,
Looking for some ideas on a bit of a quirky problem.
I have a relatively simple insurance data set made of 2 tables policy revenue and policy payments (claims). Both tables have a "Date" column" i.e. date when policy revenue (premiums) are paid and date when a claim is paid respectively.The natural link is obviously policy number.
The problem I have here is that I would like to compare premiums and revenues lets say either by year or month. What is the best way to handle these 2 differing dates? I need to have a list box where I can either select a month or year and I will have both claims and premiums for that period.
A single calendar would be difficult because you would have to choose an association by either claims date of premiums date when you want both.
Hope this makes sense.
Thanks
H
