
11th March 2005, 07:03 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 1,096
|
|
Quote:
Originally Posted by Duritz
Thanks - however the query itself is in Exel, using MS Query, rather than in Access.....
|
Hi Duritz!
I am sure you cannot use a table link in Access to give the same links in Excel unless you use a query created in Access and then opened in Excel.
Also you have to be careful if you create a link using only the horse's name, it will pick every record with that name regardless of date race num. venue etc.
You really would have to go back and redesign your tables with well defined primary keys, and avoid using the same field names in different tables, it will cause errors because the database engine does not know whether you meant hName in Horses or hName in Form?
It is very easy to get results that are inaccurate.
Also when you query past races you have to be careful that only the form parameters prior to the race date are being used!
Sorry if I confused you, if it doesn't help just forget it.
I use Access extensively but write my own front end applications to access the data.
Cheers!
|