Tag Info

New answers tagged

1

Sorry, this may not be An Answer, but I couldn't add a comment. This is surely a 'solved problem' in that hotel and reservation systems are available commercially 'off the shelf'? Why develop your own? Even if you do decide for good reason that you need to, it might well be worth investigating the data models underlying a few commercial products, if you can ...


1

Cheers for that, why MS Access has to be different to everything else? Mmm. I got to the bottom of it like you said using : G1 = SUM(CASE WHEN GroupNum = 1 THEN 1 ELSE 0 END)*BoardStatus, G2 = SUM(CASE WHEN GroupNum = 2 THEN 1 ELSE 0 END)*BoardStatus, ..... G10 = SUM(CASE WHEN GroupNum = 10 THEN 1 ELSE 0 END)*BoardStatus, G11 = SUM(CASE WHEN GroupNum = 11 ...


0

I solve it by add some extra command in terminal, like this : isql -v mydb and the result : +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | ...



Top 50 recent answers are included