casperthedog
Instructor
I wish to store the text of some childrens books (eg picture books which have only a few words on a page) in a database. Each word must be a new record as it will have a response associated with it as the child reads. For example, the table will have the fields:
ISBN, pageNo, LineNo, WordNo, ActualText, Response
This is easy to create but I then want to create a report that displays the text more or less as it appears on the page of the book. So if page one is set out like this:
'One day Goldilocks
went for a walk'
I want the report to display the words in a similar fashion e.g. on two lines with the first three words on the first line.
Currently all I can do is produce a report, grouped by ISBN, Page and line but the words are listed vertically as they are in the DATA section of the form e.g.
One
day
Goldilocks
went
for
a
walk
Please help with your ideas.
Thanks.
ISBN, pageNo, LineNo, WordNo, ActualText, Response
This is easy to create but I then want to create a report that displays the text more or less as it appears on the page of the book. So if page one is set out like this:
'One day Goldilocks
went for a walk'
I want the report to display the words in a similar fashion e.g. on two lines with the first three words on the first line.
Currently all I can do is produce a report, grouped by ISBN, Page and line but the words are listed vertically as they are in the DATA section of the form e.g.
One
day
Goldilocks
went
for
a
walk
Please help with your ideas.
Thanks.