Recent content by molly pup

Need a a validation rule to allow only "a" or "p" to be entered as data into the relevant fields, can someone help?

I am using a parameter query to return the data of an animal, the user will type in the animal ID and the query will return all the data about the animal. This works perfectly. However at the moment if the user inputs an incorrect animal ID the database just returns a blank query. I would like...

Thankyou both. Your help has been most greatfully recieved.

I have a table of animals each with a unique ear mark. I also have a table of vaccination records. When adding new records to the vaccination table via a form i would like a validation check on weather the animal actually appears in the animal table or not with an appropriate error message...

This may seem basic but I need some help. I have a table of vacinations and need to add a new record every time an animal is vacinated. I have created a form with all the fields in the table in it. But when I open it it takes me to the first record. I have had to add a button to the form to add...

Thank you again! Most helpfull of you.

Jon you are an absolute legend. I cannot thank you enough for your help. But could I please ask you one more thing. Would you mind explaining how you created the 2a querry. This will add to my at the moment basic Access knowledge. Many many thanks.

I have a table which contains vaccination history data. It includes animal ID, vaccination date and vaccination ID. Each animal will have several vaccinations over its life time. I need to run a querry that will only look at the last vaccination the animal has recieved to see it has been more...