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.
2006-11-12
00:12:19
·
1 answers
·
asked by
joemoran7
2