12th March 2005, 10:12 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by Duritz
'Cos I do the form in excel, so rather than typing in horse's names individually in an access query, I paste them into excel and hit refresh, and it queries all of the runners at once.
Is there a way I can do that in access?
|
Duritz,
That's why I set it up to have a race table and horse table and then a query in access.
What you can do is this:
Import your spreadsheet with race information to the race table.
Now run the access query and export the results into excel.
You now have the race info and corresponding horse comments on the one spreadsheet without using excel queries.
In this particular instance you don't need primary keys either, as you want all comments returned for a particular horse. |