multiable numbers in cell

D

David

I'm trying to create an index for a book I'm working on that will note the
page or pages where a Bibilical verse can be found on. Problem that I am
runing into is that I am sometimes noting that a verse or group of verses may
span consecutive page numbers in one cell! 1. The cell is noted as a "text"
type because entry may note 2 or more pages in chapter! should I have used in
cell "example" 4-8 or 4 5 6 7 8 or 4,5,6,7,8 or 4;5;6;7;8?
 
A

Al Camp

David,
Is this an Access database question, or a spreadsheet question? ("cell"?)
This newsgroup deals with Microsft Access, a relational database application. Try
this post in a newsgroup appropriate to your spreadsheet application.
 
D

David

YES this is an Access question! I could of used the word "field" in a record
if that helps? The problem remains... how to note or Display and sort as
numbers in a "text" as a "data/type"! Is there a difference in either cell or
field? I wish to sort in ascending order i.e. 4,5,6,7,8 Not
1,11,12,13...2,20...3,30...
--
Milwaukee
David M. Barker


Al Camp said:
David,
Is this an Access database question, or a spreadsheet question? ("cell"?)
This newsgroup deals with Microsft Access, a relational database application. Try
this post in a newsgroup appropriate to your spreadsheet application.
Click to expand...
 
K

Klatuu

There are no Cells in Access or any other database. Cell is a spreadsheet
term. Granted, there are some simularities, but also, some differences.

The similarity is that each can contain one data item. The operative here
is One. You cannot put multiple items of data in a field. If you do, they
become one item and any sorting or searching becomes meaningless.

The indexing you are trying to do is no simple matter. Rather than trying
to list every page a verse spans, You should consider using just the page it
start on.

David said:
YES this is an Access question! I could of used the word "field" in a record
if that helps? The problem remains... how to note or Display and sort as
numbers in a "text" as a "data/type"! Is there a difference in either cell or
field? I wish to sort in ascending order i.e. 4,5,6,7,8 Not
1,11,12,13...2,20...3,30...
Click to expand...
 
A

Al Camp

David,
Cell is a spreadsheet term. Field is the correct Access term.
I agree with Klatuu, it would be much easier to just refer to the start page.
OR...
It's not necessary to indicate 6,7,8,9,10,11,12 for a passage...
Make StartPage a number, and add a numeric field to your table called EndPage.

Passage StartPage End Page
"Some passage" 6 12

Now you can sort directly on StartPage.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


David said:
YES this is an Access question! I could of used the word "field" in a record
if that helps? The problem remains... how to note or Display and sort as
numbers in a "text" as a "data/type"! Is there a difference in either cell or
field? I wish to sort in ascending order i.e. 4,5,6,7,8 Not
1,11,12,13...2,20...3,30...
Click to expand...
 
D

David

Thanks! I may also use that concept with the "verse" range! I had read
somewhere that you could use semi-colums but the "start" and "END" (if
mulitibles) may do what I want, and as a "number" it's sortable!
 
Top