Ranges - zones of occurance

[yippie_ky_yay]

hello forum,

While looking over some old dbs we have here, I noticed that one of them lists the zones of occurance by manually typing in "Zone1" or "Zone1-4".

This seemed like something easy to fix up at first, but then I noticed that there are also entries like "Zone1-3,5-7" (meaning 1-7 with the exception of 4).

Has anyone seen a better way to standardize this?

Thanks!

-Sean

 

[Dave Eyley]

Depending on the number of zones required, you could create a checkbox for each zone. That way, the user can select any permutation of zones.

It will need some code record the selection for the tables.

Dave E

 

[Rich]

Or a multi select list box

 

[yippie_ky_yay]

Thanks for answering guys!

Those are great ideas if I ever set up user forms, but I don't really need a user-friendly answer for this - whatever will help me best for querying and reporting! I think creating columns for all 20 zones may be a bit much (there would be many blanks/nulls!)

Thanks again,

-Sean

 

[yippie_ky_yay]

Thanks Pat!

I am going to try to implement this and see how successful my reports turn out. At worst it will be a good learning experience!

Cheers!

-Sean