9th March 2005, 10:55 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Hi Duritz,
A little complicated to explain but I'll give it a shot.
I need to know exactly what you require and the field names to explain it fully, but here goes.
As your information is contained in excel spreadsheets already, you can create tables in Access and name each field the same as the spreadsheet, you would then import your current spreadsheet data into the Access tables.
So you'd have two tables for example,
1. Horses
2. Past Runs/Form
You then create a relationship based on the horse name fields in both tables.
Then create a query that pulls the horse name from the horse table and the data from the second table in date descending order.
So your query has the runs in descending date order (most recent run at the top of the table).
I know this is a little sketchy, but it's hard to explain fully without more info.
If you'd like me to make up something for you, I can do it if you supply EXAMPLES of what you're trying to achieve. You could send me dummy info, so you don't reveal your secrets, and tell me which version of Office you have too please.
racestats at hotmail dot com
|