count if function

[justme43]

I have a data base that records every client (clientdetail table)
We also record every time this person receives assistance from emergency relief. I would like to count what countries these people come from and how many people come from these countries (Service utilised table)
This also needs to be done for PostCode and a few other fields
This needs to happened between a date range weekly monthly quarterly annually
Is this a possiblity or am I over estimating Access
This is a charity that serves the community with a range of help.
Is this possible.

[MMcCarthy]

You need to look at crosstab queries. If you use the wizard to start a new query it will give you the option of crosstab queries. Play around with this for a while until you get the results you want.

[NeoPa]

It's possible, but you strike me as a little inexperienced to be jumping into something like this. It's certainly possible. In fact it's just the sort of thing databases were designed for.

Before you start (if that is indeed your plan) I would certainly recommend checking out Normalisation and Table structures. I hope it makes sense to you. It's expressed so that non-technical people can understand the language, but I cannot say how you may get on with the concepts. They are concepts someone doing this really needs to take on board though if they're to avoid much heart-ache later on.

[justme43]

you are not kidding with the inexperience Excell I am brillant with and have been able to do this. The probable is we need something that works uniformly accross all sites so I am trying access I really need this to work I will read this and also look at cross tabs.
thandyou for your time both replies I received
I have read and I am rather sure I have covered these points ty

[MMcCarthy]

Think of crosstab queries as pivot tables. I assume thats what you used when doing this in Excel.

[justme43]

thankyou I am looking at this now I am getting a little confussed at the moment with what i am doing but I will persist I am so grateful for your time