Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-19-2008, 02:51 PM   #1
ABDN Student
Registered User
 
Join Date: Jul 2008
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
ABDN Student is on a distinguished road
Simple query help please!

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
Attached Images
File Type: jpg Query.JPG (65.4 KB, 75 views)
File Type: jpg Relationship.JPG (67.7 KB, 69 views)
File Type: jpg Wrong query result.JPG (95.4 KB, 68 views)

ABDN Student is offline   Reply With Quote
Old 07-19-2008, 03:06 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,296
Thanks: 13
Thanked 4,112 Times in 4,044 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Add:

[Enter Registration]

in the criteria row under the registration field in the query grid.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 07-19-2008, 03:34 PM   #3
ABDN Student
Registered User
 
Join Date: Jul 2008
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
ABDN Student is on a distinguished road
Thanks for getting back to me. Tried that and it works!

However what I would really like to do is not have to use a pop up box that requires me to enter the registration.

I would like to enter in the registration in the query itself and then beside it the description and type of car would appear. This is because I wish to use the query as the basis of a mileage form which will allow me to enter data.

I have found a clip on you tube that shows the sort of thing I would like to be able to do:
1)User enters the cd number
2)Query displays all the relevant info about the particular cd.

I just don't understand the explanation given in the video and I dont seem to be able to do the same thing in my query.

I have attatched a screenshot of the youtube clip. Also here is the link: http://www.youtube.com/watch?v=o8kmM...eature=related

Ross
Attached Images
File Type: jpg you tube.JPG (25.7 KB, 67 views)

ABDN Student is offline   Reply With Quote
Old 07-20-2008, 02:11 AM   #4
wazz
Super Moderator
 
wazz's Avatar
 
Join Date: Jun 2004
Location: Vancouver, BC, Canada.
Posts: 1,711
Thanks: 0
Thanked 3 Times in 3 Posts
wazz will become famous soon enough
you say you'd like to "enter in the registration in the query itself" but, you have to take that literally. do you want to see the query every time and enter it there? i doubt it. so, if you don't want to do what baldy suggests, the question is: where do you want to enter the registration? probably a form. then, your query has to "read the form". query criteria: Forms!frmReg!txtEnterReg.

__________________
Access 2003 / XP Pro
"We draw our own designs
But fortune has to make that frame." - N. Peart

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
wazz is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Query based on another simple query not working vwgolfman Queries 10 07-16-2008 10:23 AM
An interesting experiment! Need others opinion on different ODBC query behaviors. Banana Queries 12 07-01-2008 08:48 PM
Simple Count Query Listerman Queries 15 03-05-2008 03:20 AM
how to query a simple table.... or so I thought! emma clare Queries 13 01-18-2006 12:39 PM
very simple query not working.... cyberpac9 Queries 4 09-22-2005 05:26 AM




All times are GMT -8. The time now is 05:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World