Thanks a lot, Allen.
Can you give me an example how to implement a parameter query in a form
without a pop up window?


Allen Browne wrote:
The table you have is structured like a spreadsheet rather than a database.
If you build it that way, you lose most of the power and reliability that a
relational database can give you, and you make it difficult to query the
results.

For a suggestion on how to build relational tables to handle school grades,
see this example:
Relationships between Tables
at:
http://allenbrowne.com/casu-06.html

If you have never built or seen a relational design before this may sound
strange, but it is the absolute core understanding to grasp of how
relational databases like Access work.

Dear Friends,
I have a table named "class_grades" and with the fields of "First Name",
[quoted text clipped - 173 lines]
Eleanor Yeh 19 85 85.5 86.3 WA
Matt Young 19 84 84.5 85.3 UT

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201006/1