Query by form problem

#1 August 22nd, 2005, 03:00 PM

Hi Everyone,
I am an student of O'level. I was going through a very simple database on
our school library as a part of my computing project. Only four tables are
the
1.students, 2.books, 3.loans, 4.book type.Most of the tables dont have more
than 5 fields.
Now, I wonder How can I make a query form so that giving entry on the form
will give me some query result. Could anyone plz help me on

Thanks to everyone

#2 August 22nd, 2005, 03:03 PM

Hey,
Well, if you wanted to query all the information(on all 5 tables) you would
need to setup some sort of relationship between all the tables(a field that
links each table to each other) - once you have accomplished this, then you
can build your query as needed.

Hope this helps.
-MK-

"Dips" wrote:

Hi Everyone,
I am an student of O'level. I was going through a very simple database on
our school library as a part of my computing project. Only four tables are
the
1.students, 2.books, 3.loans, 4.book type.Most of the tables dont have more
than 5 fields.
Now, I wonder How can I make a query form so that giving entry on the form
will give me some query result. Could anyone plz help me on

Thanks to everyone

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Requerying a pop up form to display in the main form	Jennifer P	Using Forms	13	April 5th, 2005 06:59 PM
Another Query by Form Problem	AJ	Running & Setting Up Queries	6	January 12th, 2005 10:19 PM
Here's a shocker	Mike Labosh	General Discussion	2	October 26th, 2004 05:04 PM
Print	Taher	Setting Up & Running Reports	1	August 31st, 2004 09:07 PM
Display Parameter from Form on Report	sara	Setting Up & Running Reports	10	July 19th, 2004 04:54 PM