ABDN Student
Registered User.
- Local time
- Yesterday, 20:03
- Joined
- Jul 18, 2008
- Messages
- 16
Hi all,
I really do require some help for a university project and as you can probably tell from below my knowledge of access is "limited" to say the least.
I am using MS Access 2007.
I wish to create a query that will when I enter the registration of a car, pull up what type of car it is and a short description of the car.
The tables I have created are:
1) Car registration and type of car
2) Description of car
Please note for simplicity that the registration for each cure is simply a single number.
Please note also that the description for each car is for each "type" of car not for each individual car.
However every time I create a query I run into problems. I run the query and I get the full list of car descriptions and registration. I simply want a query that does the following:
1) I enter the registration
2) Query displays car description and type of car
I just want the results to display when I physically enter the registration in the query, not just give me the whole LIST when I run the query.
I have attached a screenshot of my relationship and query. Also I have attatched a screenshot of the query results that I don't want.
I would be REALLY REALLY grateful if someone on this forum could help me out and tell me what is wrong with the relationships and query I have done.
Many thanks,
Ross
I really do require some help for a university project and as you can probably tell from below my knowledge of access is "limited" to say the least.
I am using MS Access 2007.
I wish to create a query that will when I enter the registration of a car, pull up what type of car it is and a short description of the car.
The tables I have created are:
1) Car registration and type of car
2) Description of car
Please note for simplicity that the registration for each cure is simply a single number.
Please note also that the description for each car is for each "type" of car not for each individual car.
However every time I create a query I run into problems. I run the query and I get the full list of car descriptions and registration. I simply want a query that does the following:
1) I enter the registration
2) Query displays car description and type of car
I just want the results to display when I physically enter the registration in the query, not just give me the whole LIST when I run the query.
I have attached a screenshot of my relationship and query. Also I have attatched a screenshot of the query results that I don't want.
I would be REALLY REALLY grateful if someone on this forum could help me out and tell me what is wrong with the relationships and query I have done.
Many thanks,
Ross