Hi
I am looking for advise on how to summarise info on a form which is date specific. The example is that I want to provide management with a form that shows a summary of various key performance indicators, like monthly sales, monthly connections, monthy quotes, annual sales, total no of contracts.
The problem I have is mixing the different parameters ie monthly and annual and showing them all on the same form.
Does any one know how to get Access to recognise the current month and then query to find all the sales that were done this month, for example, as well as returning the total contracts sold? Or is there another way of doing this?
thanks in advance
Darren
I am looking for advise on how to summarise info on a form which is date specific. The example is that I want to provide management with a form that shows a summary of various key performance indicators, like monthly sales, monthly connections, monthy quotes, annual sales, total no of contracts.
The problem I have is mixing the different parameters ie monthly and annual and showing them all on the same form.
Does any one know how to get Access to recognise the current month and then query to find all the sales that were done this month, for example, as well as returning the total contracts sold? Or is there another way of doing this?
thanks in advance
Darren
