Easy question?

[Alfred S.]

Hi,
I have a question. Let me describe my situation.

I have a table of books. This table includes the name,
number of pages, and author of each book.

I have another table that groups books together into kits
of 3-6 books. Each kit has its own number (Primary Key).
I created the fields in this table using the Lookup Wizard
so that kit creation would be simpler with the use of a
drop down list.

Here is my query question. I have a query that brings up
the list of books based on the kit number I enter. In this
query, I want to be able to do some calculations based on
the number of pages of each book in the kit. How do I
reference the pages for book1?

Here is my table information

Table1-Books Table:
Primary Key Author Title Pages

Table2-Kits Table:
Primary Key Book1 Book2 Book3 Book4 Book5 Book6

Query1-Kit Query:
Primary Key Book1 Book2 Book3 Book4 Book5 Book6

I hand to add a column in the query that is similar to
this: WOW:IIF(book1Pages>500,1,0) for each book. But how
do I reference Book1pages? I have a feeling this is really
simple...