Entering Number Ranges

[Lister]

I am only doing a very simple job- I am making a database of my family's CDs,
DVDs, etc. Many of the DVDs are of television series' and thus have many
episodes per disk. Is there an easy to way to enter a range (say 1-26) in an
"Episode" field and have the range recognised as numbers, not simply as text?
That means that if I searched for Star Trek, Episode 48, it would give me the
number of the disk that contained that information.

I am using Access 2007. Thankyou for your help.

 

[scubadiver]

Text is text and a number is a number and they are distinguished by access.
The only alternative I can think of is have two integer fields which stores
the lowest and highest episode number.

 

[BruceM]

You may be able to come up with a way to parse such a field, provided you
are very consistent about how you enter the data, although numbers or
hyphens in the show's name may prove troublesome. Fields for EpNumStart and
EpNumEnd may be the best solution. In any case, how a search would work
depends in part on how you enter the search parameters. One idea is that
you could select the show first. If there are values in EpNumStart and
EpNumEnd, a text box could appear in which you enter the episode number.