B
blee via AccessMonster.com
Hello and thanks for your help. I'm new to Access and am trying to figure
something out. I posted a similar question last week, but am still getting
the wrong data in my query. Any help much appreciated.
I have two tables, one for Athletes (and demographics) and one for Injuries.
They are related on Athlete ID, an AutoNumber in Athlete table, foreign key
in Injury table.
When I run my query (in order to print a report), something isn't right. For
example, if I use the Athlete ID number from the Injury table and get the
first/last name from Athlete table, it pulls the correct # but relates it to
the wrong athlete name. If I use the Athlete ID and first/last name from the
Athletes table, it gets the wrong ID # and wrong name. Either way, the other
data is correct (ie injury location, date of injury, etc.)
I've made and re-made both tables and am at a loss as to what I'm missing.
Thanks
Brian
something out. I posted a similar question last week, but am still getting
the wrong data in my query. Any help much appreciated.
I have two tables, one for Athletes (and demographics) and one for Injuries.
They are related on Athlete ID, an AutoNumber in Athlete table, foreign key
in Injury table.
When I run my query (in order to print a report), something isn't right. For
example, if I use the Athlete ID number from the Injury table and get the
first/last name from Athlete table, it pulls the correct # but relates it to
the wrong athlete name. If I use the Athlete ID and first/last name from the
Athletes table, it gets the wrong ID # and wrong name. Either way, the other
data is correct (ie injury location, date of injury, etc.)
I've made and re-made both tables and am at a loss as to what I'm missing.
Thanks
Brian