Hotel Database Problem?

Question

I am doing a database for a hotel reservation system on access. I have a table called room category. All of the single rooms are numbers 100-103, all doubles 122-125, all suites 111-113, etc....

I need an IF formula in the room number field which says, if the room type field = single, then room numbers between 100-103, if souble then 122-125, etc......

I assume this IF statement goes in the input mask.

Also, as it is one field, you need to link the IF statements

P.S. I cannot alter the design of the tables.

Answer 1

Create/add a table of room types. For room type single the numbers are 100-103, etc. Then when an inquiry is made asking for the room numbers for a room type, move those numbers to the answer field. All this of course depends on the software you are using to process information from the access database.