Finishing Touches

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Greetings again. I have received a lot of help from the
indomitable MS ACESS MVPs, who gave me the following code:

SELECT DISTINCT BIBLE.D, Concatenate("SELECT [E] FROM
BIBLE WHERE [D]=""" & [D] & """ ORDER BY KeyID") AS Phrase
FROM BIBLE

The problem is that the contents that end up in "Phrase"
field are truncated, since some of the Bible verses are
quite long (each word is one row). Is there any way of
getting around this limitation, say by dumping the
contents into a memo field? I am a newbie with MS ACCESS,
as you can see, so could you please explain how to do this
in very easy English, step-by-step? Thanks.
 
First create a query of unique D values
===qgrpD============
SELECT D
FROM BIBLE
GROUP BY D;

Then try:
SELECT D, Concatenate("SELECT [E] FROM
BIBLE WHERE [D]=""" & [D] & """ ORDER BY KeyID") AS Phrase
FROM qgrpD;
 
Back
Top