Hi Everybody,
I am new to this Forum and new the Microsoft Acces and i hope you guys can help me out with some questions?
A brief description of what I am doing and why I want to learn how to use Acces. Since August last year I've started working on a Dairy/Beef farm in Kenya. All our records are kept in books, on cards and in boxes. Basically a lot of data in a lot of different places. We all agree digitalising these records would be a great idea but where to start... The farm has records going back to 1959 so there is a lot to be processed. So over the last couple of weeks I've been looking how we could digitalize this data the best and most cost friendly way. I know how to use excel very well but I think the amount of data and the fact it would be really nice to run certain queries made me decide to learn how to use MS Acces.
So over the last week I've been practising with Tables, Forms, Queries and Reports. The general problems I started running into are primarily related to making the reports show the right data (but that might be related to how I run queries?). I thought i would post one of my problems in this post and see how you guys can help me from here. I hope by solving this problem to get more fimiliar with Acces and improve me skills.
Problem:
In the pictures below i've shown how I am processing our dairy herd into Acces. Basically i've made 4 tables; 1 for general cow detail such as date of birth, number, name etc..., 1 for calving records of cows, 1 for production records of cows and 1 for service records of cows. In all these tables i've included the number and names of the cows as i thought that would be easy to link (make relationships) the tables with each other. after doing these tables i've created 4 forms that make entering the data easier. After this i started experimenting with Queries and reports. So for this example I want to create a report that shows me the general cow details (Number, name, Sire info, Dam info, Date of Birth) on the top. In the 'detail' part of the report i then want to show the Calving dates, service records and production records for this same cow.
What I've done:
I've been trying to create a report that shows the general cow details in the page header and than show all the calving records, production records and service records in the 'detail' part. The problem i run into is that the report will only show the 1st calf, the 1st service record, the 1 production records and doesnt show all the others. Any idea on how I can achieve something like this?
Please see the attached picture to see what i've done,
Thanks in advance!
Kiko