Thanks lomaca. In fact, I don't really have a prob with the way my data is returned to excel via my MS Query queries, as when I do the form I WANT every record returned, and I have made the query it runs through in Access sorted in date order, so that when the MS Query accesses the records they are sorted that way. Essentially, I end up with every run of the horse in the database, from most recent back to day dot, which is how I want it.

What I need is this:

To be able to have another table to which I can add other odds and sods about horses, so that I can extract this info also. Say I want to put a general comment about a horse, I need somewhere to put it where it can be retrieved in a query in excel. Or the horse's age, or prizemoney won so far, or what it's favourite colour is - stuff that doesn't come in normal results which are the meat and two veg of keeping the normal "race" DB up to date. This new DB - horse - I would also like to only be allowed to have one line for each horse, and should I want to update the info on a particular field of that horse, how do I do it without eliminating the other info?

Know what I mean?