how can i combine 3 table

[mezzanine1974]

lets say we have 3 storey building in use. At each floor, there are
several type of furnitures. So we have produced 3 seperate table which
has only one field called `furniture name`.
I would like to see furnitures in a single table (query result) which
will have 3 fields (Floor1, Floor2 and Floor3).
If, for example, `Furniture A` exist on only Floor3, Query result will
be null for Floor 1 and Floor2, but Floor3.
Thanks for your support.

 

[Jeff Boyce]

I'll urge you to reconsider your design/approach. What you described sounds
like a spreadsheet, not a relational database (i.e. Access).

Instead, consider a table design that looks something like:

trelFurniturePlacement
FurniturePlacementID
FurnitureID (what piece of furniture, from the tblFurniture table)
FloorNumber

This design doesn't require "blank" fields, as there will be only one record
per furniture/floor combination.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/