Recent content by JFTE

Thanks.

Thanks I will give it a try. Thank you. The Client is either a single parent or they would be the carer \ parent of any dependents. Fed does refer to meals provided. We keep a running total of the number of individuals that are fed at each session. I split the dependents from the clients...

Thanks for your in depth reply and welcome. I curtailed some of the fields in the Client table such as illness and disability and benefits but forgot to do the same with the dependents table. We use the term client for the person who turns up at the charity. They then inform us about their...

Thanks for your reply. I tried to post the database last night but the site told me it was too large to post.

Thanks for your reply. I have put the Clients and dependents in one table and was trying to calculate age demographics from that one table as my original post stated. I couldn't get the formulae to give me the answers that I wanted.

Thank you for your reply. I will have a very good look at your schematic. First thoughts are that this is far more complicated than I would need. I am helping out in a very small charity which at the moment has only 140 clients, most of whom we will only see once or twice but they are kept on...

This is what I started with. I couldn't get the age demographics to work, so I created another table with the Dependents in with the clients.

Thank you. I will watch the video.

Thanks for your reply. I will investigate it.

I started with that but if a client didn‘t have a dependent then the results weren’t correct.

Thanks for the reply. Can you explain what you mean by normalisating the database?

Hi, I am trying to perform a query to find out the age demographics of the clients and their dependents in my database. I have a clients table (ClientsT) with fields DOBC (date of birth of client), DOBD1 (date of birth Dependent 1) and DOBD2. Some clients do not have any dependents. I can...

Hi, I have a basic knowledge of Access, taught it as part of a GCSE IT (14-16 years old qualification in the UK), course a few years ago. I help out in a small charity and would like to build a database to help with Client records and getting data for grant applications. I am hoping I can...