Simple Query Question

Greetings. I deeply appreciate the help the MS MVPs have
given me (especially John Spencer). I have a quick
question about the following query that Mr. Spencer gave
me yesterday:

SELECT DISTINCT [A],
Concatenate("SELECT [C] FROM BIBLE WHERE [A]=""" & [A]
& """ ORDER BY KeyID") AS Phrase
FROM BIBLE

Column A contains Bible verses in the following format:
Gen 1:1, Gen 1:2 (...), Exo 1:1, Exo 2:1, right up through
Revelation (Rev 1:1, Rev 2:1, etc.). Sometimes when I run
the query I want it restricted to the display of one
specific book, say Leviticus (Lev). I realize this is an
easy thing to accomplish, but because I am a newbie, I
can't figure out how to do this, even though I have
searched my manual, but so far to no avail. Could someone
please tell me how to do this, and could you please keep
the explanation as simple as possible? Thanks.

Rebecca, there are so many good Bible software programs - including
freeware - that what you are doing seems like lots of work for something you
could achieve more easily?

Some of the software on the market uses the Strongs numbers as in index to
the Hebrew and Greek root words (as listed in the back of a Strongs
Condordance). Part of the issue here is that there is not a one-to-one
correspondence between Hebrew/Greek words and English words. Search for
"interlinear" if you want to see the typical output this produces.

Regarding your specific question, you would need to create a table of Bible
Books, indicating the order in which they occur. The fields would be:
BookID Number A value between 1 (Gen) and 66 (Rev).
BookName Text
You could then create a query that limits to book 3 if you want to search
Leviticus.


--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rebecca" wrote in message
...
Greetings. I deeply appreciate the help the MS MVPs have
given me (especially John Spencer). I have a quick
question about the following query that Mr. Spencer gave
me yesterday:

SELECT DISTINCT [A],
Concatenate("SELECT [C] FROM BIBLE WHERE [A]=""" & [A]
& """ ORDER BY KeyID") AS Phrase
FROM BIBLE

Column A contains Bible verses in the following format:
Gen 1:1, Gen 1:2 (...), Exo 1:1, Exo 2:1, right up through
Revelation (Rev 1:1, Rev 2:1, etc.). Sometimes when I run
the query I want it restricted to the display of one
specific book, say Leviticus (Lev). I realize this is an
easy thing to accomplish, but because I am a newbie, I
can't figure out how to do this, even though I have
searched my manual, but so far to no avail. Could someone
please tell me how to do this, and could you please keep
the explanation as simple as possible? Thanks.