Range of roman numbers

[Dream.Van]

Hi,

I want to search in a interval of roman numbers. I have 2 fields (RangeStart and RangeEnd). They represent lines of a grid on maps. Unfortunately I have occasional letters in my data, so they have to be text fields. I don't have any formatin for my roman numbers(the're entered like letters) I think I'm going to have to change that.

When I want to search I use either the roman numbers or the letters, not both at the same time. Is there a way to make this work?

Hope I'm clear enough
Thank's for helping

 

[Steve R.]

I have 2 fields (RangeStart and RangeEnd). They represent lines of a grid on maps. Unfortunately I have occasional letters in my data, so they have to be text fields. (emphasis added)

Most maps that I am familiar with define a grid by a letter and number, such as A1 or F8. Complicating this issue is the fact that these grid coordinates are repeated for each page, which means that the page number is also part of the search string that uniquely identifies the grid. (Something like this "49A1")

1. Is there a standard format? What is the format?
2. What is the "first" possible grid range , what is the "last" possible grid range.
3. The word "occasional" could be a problem. Does it mean something?

 

[Dream.Van]

The format isn't regular which causes most the problems. Source of the problem : All townships aren't the same size. The maps have townships they cover and sometime it only covers part of a township.
The township is grided.
The grid have Ranges(roman numbers) and Lots(decimal numbers). For the lots I'm okay, they are all numbers.

Ranges start at 1 and can go out to to 14. AND some guy decided that a few townships had a Range A, B, C, that are in a diagonal with de rest of the grid. (maybe to follow the water line in some region???)

Lots start at 1 also and go out to 406 (that's the higher I got yet).

[FONT=Courier New]Example[/FONT]
 
[FONT=Courier New]Township 56 - Bob            They aren't all square either[/FONT]
 
[FONT=Courier New]Ranges:        ______________[/FONT]
[FONT=Courier New]        A  /      /      /[/FONT]
[FONT=Courier New]          /______/______/______ [/FONT]
[FONT=Courier New]      B  /      /      /      / [/FONT]
[FONT=Courier New]        /______/______/______/[/FONT]
[FONT=Courier New]I         |______|______|______|[/FONT]
[FONT=Courier New]II        |______|______|______|[/FONT]
[FONT=Courier New]III       |______|______|______|______________[/FONT]
[FONT=Courier New]IV               |______|______|_______|______|[/FONT]
 
[FONT=Courier New]Lots :       1      2      3       4       5[/FONT]

Here's how I've got this sorted. I have 3 tables, Maps, Townships, Link_Map_TWP that gives me a many to many relation because I can also have many townships on a same map.

In my link table I've got fields :

[FONT=Courier New]    MapID | TWPID | StartRange | EndRange | StartLot | EndLot[/FONT]
 
[FONT=Courier New]example:23    56         A                       1         2[/FONT]
[FONT=Courier New]       23    56         B                       1         3[/FONT]
[FONT=Courier New]       23    56         I           III         1         3[/FONT]
[FONT=Courier New]       23    56         IV                      2         5[/FONT]

So lets say I'm looking for a map in that township in Range I to IV, Lot 3 it sould give the map above

The lots aren't a problem I use a form to create a string like [startlot] >= 3 And [endlot] >= 4

Maybe associating the Letters to a number in vba and store it as a number in access?