how to create table like this format.

[umairgill]

room	no of chairs	no of tables	no of beds
bed room	2	1	2
dining room	6	1	0
sitting room	4	1	0
wash room	0	1	0

HOW CAN I CREATE A TABLE LIKE ABOVE FORMAT AS AN ACCESS REPORT?

ALSO, WHAT IS THIS TYPE OF DATA TABLE CALLED?

[June7]

What you show looks like the output of a CROSSTAB query that uses a normalized table as data source.

Building a report to run perpetually based on CROSSTAB query can be difficult. Review http://allenbrowne.com/ser-67.html