By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Suggestions for Date and Count?

P: n/a
MVA
Hi everyone,

I am developing a small database for a voluntary organisation in the UK
using MS Access, it's a basic membership type database. One of the purpose
of this database is to give specific statistics for their funding and annual
reports.

I have a table that includes a list of the organisation's members, along
with a date of when the member applied and went on a waiting list, as well
as a date of when they actually came off the waiting list and became
members.

What I'm struggling with is I need to calculate how many people joined the
waiting list, and how many people became members in Each Financial Year (1st
April to 31st March)... does anyone have any suggestions as to how I should
go about doing this? Even without the "Each Financial Year" constraint I'm
not sure how I would approach this... The one way I did thought of was to
have a list of financial years where there is an option for the user (the
organisation) to add to the list, and then do a query with the Financial
Year as some sort of variable? But I have no clue how I would do that in
Code or query...

I'm hoping someone can show me a suggestion or solution to how this could be
done.

Many thanks in advance.

Regards
Will
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.