If long-term beds are reduced, then it won't be possible to do that and normal sickbeds will also be adversely affected.

For a display where the data items increase and decrease I think you are best making use of a spreadsheet program, not Access.