I am trying to generate a list of Nursing Homes, including the number of licensed beds in each facility. In many cases there are different types of beds within a facility (e.g. Long term care, residential, ventilator). How would I suppress printing of the label (bed type description), if that type of bed does not exist for a given facility.
The following is a sample of the output from the report as well as from the query that was used as the Control Source for this report.
Thank you in advance for any help that you can give me. ATLANTIC Beds
ABSECON MANOR NURSING & REHABILITAT LONG TERM CARE BEDS 130
1020 PITNEY ROAD RESIDENTIAL BEDS
ABSECON 08201 ASSISTED LIVING BEDS
COMPREHENSIVE
609 646-5400 PERSONAL CARE BEDS
MARLENE DZIUBA ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS 32
MEADOWVIEW NURSING HOME LONG TERM CARE BEDS 180
235 DOLPHIN AVENUE RESIDENTIAL BEDS
NORTHFIELD 08225 ASSISTED LIVING BEDS
COMPREHENSIVE
609 645-5955 PERSONAL CARE BEDS
WILTON BENNET ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS
EASTERN PINES CONVALESCENT CENTER LONG TERM CARE BEDS 208
29 N. VERMONT AVENUE RESIDENTIAL BEDS
ATLANTIC CITY 08401 ASSISTED LIVING BEDS
COMPREHENSIVE
609 344-8900 PERSONAL CARE BEDS
KATHLEEN HIGGINS ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS
PROVIDER DOHID COUNTY ATG_FACILITY.NAME STREET1 CITY STATE ZIPCODE AREA_CODE PHONE_NUMB ADMFIRST ADMLAST MEDICAID MEDICARE BED_TYPE_CODE Facility2.NAME
315428 NJ62014 UNION ABBOTT MANOR CONV CTR 810 CENTRAL AVENUE PLAINFIELD NJ 07060 908 757-0696 MARIA LAPID -1 -1 0 ABBOTT MANOR CONV CTR
NJ60115 ATLANTIC ABSECON MANOR NURSING & REHABILITAT 1020 PITNEY ROAD ABSECON NJ 08201 609 646-5400 MARLENE DZIUBA 0 0 0 ABSECON MANOR NURSING & REHABILITAT
315244 NJ60115 ATLANTIC ABSECON MANOR NURSING & REHABILITAT 1020 PITNEY ROAD ABSECON NJ 08201 609 646-5400 MARLENE DZIUBA -1 -1 0 ABSECON MANOR NURSING & REHABILITAT
NJ60201 BERGEN ALLENDALE NURSING HOME 85 HARRETON ROAD ALLENDALE NJ 07401 201 825-0660 MICHAEL GIANCARLO 0 0 0 ALLENDALE NURSING HOME
NJ60201 BERGEN ALLENDALE NURSING HOME 85 HARRETON ROAD ALLENDALE NJ 07401 201 825-0660 MICHAEL GIANCARLO 0 0 0 ALLENDALE NURSING HOME
315305 NJ61201 MIDDLESEX AMBOY CARE CENTER ONE LINDBERGH AVENUE PERTH AMBOY NJ 08861 732 826-0500 GERALD ROTH -1 -1 0 AMBOY CARE CENTER
315044 NJ61902 SUSSEX ANDOVER SUBACUTE & REHAB-I 1 O'BRIEN LANE ANDOVER NJ 07821 973 383-6200 SONIA VELMONTE -1 -1 0 ANDOVER SUBACUTE & REHAB-I
315248 NJ61901 SUSSEX ANDOVER SUBACUTE & REHAB-II 99 MULFORD ROAD ANDOVER NJ 07821 973 383-6200 CARLA TURCO-KIPIANI -1 -1 0 ANDOVER SUBACUTE & REHAB-II
315336 NJ61109 MIDDLESEX APPLEGARTH CARE CENTER 189 APPLEGARTH ROAD MONROE TOWNSHIP NJ 08831 609 448-7036 HARRY VEALE -1 -1 0 APPLEGARTH CARE CENTER
315292 NJ61343 MONMOUTH APPLEWOOD ESTATES ONE APPLEWOOD DRIVE FREEHOLD NJ 07728 732 780-7370 VIOLETA PETERS -1 -1 0 APPLEWOOD ESTATES
NJ61343 MONMOUTH APPLEWOOD ESTATES ONE APPLEWOOD DRIVE FREEHOLD NJ 07728 732 780-7370 VIOLETA PETERS 0 0 0 APPLEWOOD ESTATES
315036 NJ60706 ESSEX ARBOR GLEN CENTER POMPTON AVE & E LINDSLEY ROAD CEDAR GROVE NJ 07009 973 256-7220 DENISE SCOTT -1 -1 0 ARBOR GLEN CENTER
315333 NJ61537 OCEAN ARBORS CARE CENTER 1750 RT 37 W TOMS RIVER NJ 08757 732 914-0090 CHRISTINE SMITH -1 -1 0 ARBORS CARE CENTER
315111 NJ61105 MERCER ARCADIA NURSING & REHABILITATION 1501 STATE HIGHWAY 33 TRENTON NJ 08690 609 586-1114 LORI GABRIEL -1 -1 0 ARCADIA NURSING & REHABILITATION
315119 NJ61301 MONMOUTH ARNOLD WALTER NURSING HOME 622 SOUTH LAUREL AVENUE HAZLET NJ 07730 732 787-6300 BENZION SCHACHTER -1 -1 0 ARNOLD WALTER NURSING HOME
315064 NJ62002 UNION ASHBROOK NURSING HOME 1610 RARITAN ROAD SCOTCH PLAINS NJ 07076 908 889-5500 MARGARET DEGNAN -1 -1 0 ASHBROOK NURSING HOME
315115 NJ61504 OCEAN ATLANTIC COAST REHAB & HEALTH CARE 485 RIVER AVENUE LAKEWOOD NJ 08701 732 364-7100 SIMON SHAIN -1 -1 0 ATLANTIC COAST REHAB & HEALTH CARE
315325 NJ61302 MONMOUTH ATLANTIC HIGHLANDS NURSING HOME 8 MIDDLETOWN AVENUE ATLANTIC HIGHLANDS NJ 07716 732 291-0600 ROBERT KASZIRER -1 -1 0 ATLANTIC HIGHLANDS NURSING HOME
315286 NJ61325 MONMOUTH AVANTE AT RED BANK 100 CHAPIN AVENUE RED BANK NJ 07701 732 741-8811 JEFFREY VEGH -1 -1 0 AVANTE AT RED BANK
The following is a sample of the output from the report as well as from the query that was used as the Control Source for this report.
Thank you in advance for any help that you can give me. ATLANTIC Beds
ABSECON MANOR NURSING & REHABILITAT LONG TERM CARE BEDS 130
1020 PITNEY ROAD RESIDENTIAL BEDS
ABSECON 08201 ASSISTED LIVING BEDS
COMPREHENSIVE
609 646-5400 PERSONAL CARE BEDS
MARLENE DZIUBA ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS 32
MEADOWVIEW NURSING HOME LONG TERM CARE BEDS 180
235 DOLPHIN AVENUE RESIDENTIAL BEDS
NORTHFIELD 08225 ASSISTED LIVING BEDS
COMPREHENSIVE
609 645-5955 PERSONAL CARE BEDS
WILTON BENNET ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS
EASTERN PINES CONVALESCENT CENTER LONG TERM CARE BEDS 208
29 N. VERMONT AVENUE RESIDENTIAL BEDS
ATLANTIC CITY 08401 ASSISTED LIVING BEDS
COMPREHENSIVE
609 344-8900 PERSONAL CARE BEDS
KATHLEEN HIGGINS ADULTDAY SLOTS
PEDDAY SLOTS
VENTILATOR BEDS
BEHAVIORAL
MANAGEMENT BEDS
PROVIDER DOHID COUNTY ATG_FACILITY.NAME STREET1 CITY STATE ZIPCODE AREA_CODE PHONE_NUMB ADMFIRST ADMLAST MEDICAID MEDICARE BED_TYPE_CODE Facility2.NAME
315428 NJ62014 UNION ABBOTT MANOR CONV CTR 810 CENTRAL AVENUE PLAINFIELD NJ 07060 908 757-0696 MARIA LAPID -1 -1 0 ABBOTT MANOR CONV CTR
NJ60115 ATLANTIC ABSECON MANOR NURSING & REHABILITAT 1020 PITNEY ROAD ABSECON NJ 08201 609 646-5400 MARLENE DZIUBA 0 0 0 ABSECON MANOR NURSING & REHABILITAT
315244 NJ60115 ATLANTIC ABSECON MANOR NURSING & REHABILITAT 1020 PITNEY ROAD ABSECON NJ 08201 609 646-5400 MARLENE DZIUBA -1 -1 0 ABSECON MANOR NURSING & REHABILITAT
NJ60201 BERGEN ALLENDALE NURSING HOME 85 HARRETON ROAD ALLENDALE NJ 07401 201 825-0660 MICHAEL GIANCARLO 0 0 0 ALLENDALE NURSING HOME
NJ60201 BERGEN ALLENDALE NURSING HOME 85 HARRETON ROAD ALLENDALE NJ 07401 201 825-0660 MICHAEL GIANCARLO 0 0 0 ALLENDALE NURSING HOME
315305 NJ61201 MIDDLESEX AMBOY CARE CENTER ONE LINDBERGH AVENUE PERTH AMBOY NJ 08861 732 826-0500 GERALD ROTH -1 -1 0 AMBOY CARE CENTER
315044 NJ61902 SUSSEX ANDOVER SUBACUTE & REHAB-I 1 O'BRIEN LANE ANDOVER NJ 07821 973 383-6200 SONIA VELMONTE -1 -1 0 ANDOVER SUBACUTE & REHAB-I
315248 NJ61901 SUSSEX ANDOVER SUBACUTE & REHAB-II 99 MULFORD ROAD ANDOVER NJ 07821 973 383-6200 CARLA TURCO-KIPIANI -1 -1 0 ANDOVER SUBACUTE & REHAB-II
315336 NJ61109 MIDDLESEX APPLEGARTH CARE CENTER 189 APPLEGARTH ROAD MONROE TOWNSHIP NJ 08831 609 448-7036 HARRY VEALE -1 -1 0 APPLEGARTH CARE CENTER
315292 NJ61343 MONMOUTH APPLEWOOD ESTATES ONE APPLEWOOD DRIVE FREEHOLD NJ 07728 732 780-7370 VIOLETA PETERS -1 -1 0 APPLEWOOD ESTATES
NJ61343 MONMOUTH APPLEWOOD ESTATES ONE APPLEWOOD DRIVE FREEHOLD NJ 07728 732 780-7370 VIOLETA PETERS 0 0 0 APPLEWOOD ESTATES
315036 NJ60706 ESSEX ARBOR GLEN CENTER POMPTON AVE & E LINDSLEY ROAD CEDAR GROVE NJ 07009 973 256-7220 DENISE SCOTT -1 -1 0 ARBOR GLEN CENTER
315333 NJ61537 OCEAN ARBORS CARE CENTER 1750 RT 37 W TOMS RIVER NJ 08757 732 914-0090 CHRISTINE SMITH -1 -1 0 ARBORS CARE CENTER
315111 NJ61105 MERCER ARCADIA NURSING & REHABILITATION 1501 STATE HIGHWAY 33 TRENTON NJ 08690 609 586-1114 LORI GABRIEL -1 -1 0 ARCADIA NURSING & REHABILITATION
315119 NJ61301 MONMOUTH ARNOLD WALTER NURSING HOME 622 SOUTH LAUREL AVENUE HAZLET NJ 07730 732 787-6300 BENZION SCHACHTER -1 -1 0 ARNOLD WALTER NURSING HOME
315064 NJ62002 UNION ASHBROOK NURSING HOME 1610 RARITAN ROAD SCOTCH PLAINS NJ 07076 908 889-5500 MARGARET DEGNAN -1 -1 0 ASHBROOK NURSING HOME
315115 NJ61504 OCEAN ATLANTIC COAST REHAB & HEALTH CARE 485 RIVER AVENUE LAKEWOOD NJ 08701 732 364-7100 SIMON SHAIN -1 -1 0 ATLANTIC COAST REHAB & HEALTH CARE
315325 NJ61302 MONMOUTH ATLANTIC HIGHLANDS NURSING HOME 8 MIDDLETOWN AVENUE ATLANTIC HIGHLANDS NJ 07716 732 291-0600 ROBERT KASZIRER -1 -1 0 ATLANTIC HIGHLANDS NURSING HOME
315286 NJ61325 MONMOUTH AVANTE AT RED BANK 100 CHAPIN AVENUE RED BANK NJ 07701 732 741-8811 JEFFREY VEGH -1 -1 0 AVANTE AT RED BANK
