R
RipperT
I have a table that contains prison bunk numbers:
1-101B
1-101T
1-102B and so on
1 means housing unit one
hyphen
101 is the cell number
B or T is bottom or top bunk
I have unit one done and it contains cells 101B through 262T inclusive. How
would I write an expression for an update query to create housing units
2,3,4,5,6 and 7 in the same table? Cell numbers would all be the same.
Many thanx!
Rip
1-101B
1-101T
1-102B and so on
1 means housing unit one
hyphen
101 is the cell number
B or T is bottom or top bunk
I have unit one done and it contains cells 101B through 262T inclusive. How
would I write an expression for an update query to create housing units
2,3,4,5,6 and 7 in the same table? Cell numbers would all be the same.
Many thanx!
Rip