various data in one row

[guihualinux]

hi guys. I´m trying put various data in one row. Like this:

It is possible? Does someone know how to do?

 

[jdraw]

Can you describe to readers what this data and layout represent? Any context info would be appreciated.

 

[guihualinux]

Can you describe to readers what this data and layout represent? Any context info would be appreciated.

It´s about hotels rooms.


Room number | Type (number of people allowed in the room) | Views | Guest | Date

And i´m tryingo to put 2 guests in one room.

 

[jdraw]

Well, you are posting in a Access (database) forum, so there are some critical concepts with relational database that may apply. Each table contains information about a single subject. You may also research Normalization

It´s about hotels rooms.

Suggests, there could be guests/occupants of a hotel room(s). Occupancy could be for 1 or many Days.

So you may be looking at tables for:

Guest/Customer
Room
RoomType
Occupancy/Booking

The facility has 1 or many Rooms
At any time 1 or more rooms may be occupied
At any time 1 or more rooms could be undergoing maintenance and be unavailable
At any time 1 or more rooms could be available for booking
1 or more guests could make a Booking
A booking is a rental for 1 or more rooms by 1 or more guests for a stated period of time
The facility's rooms may be of 1 or may types
.....
Draft data model from Barry Williams' site that may offer some insight.

 

[theDBguy]

Hi. Welcome to AWF!

You can do that using a Report.

 

[guihualinux]

Can you describe to readers what this data and layout represent? Any context info would be appreciated.

Basically, I want to transform this:

To this:

 

[Gasman]

Set Hide Duplicates to Yes in the detail line.

 

[Pat Hartman]

The hide duplicates applies to REPORTING. You NEVER hide duplicates in a table, query, or form. Access is not Excel. When you have repeating data in a table, you almost always have a design problem. The repeating data belongs in a parent table and the specific data belongs in a child table with a reference to the parent. The reference field is called a foreign key (FK for short). The FK in the child table = the PK (primary key) of the parent table and that connects the two tables so you can pull the data together when you need to.

 

[Gasman]

I thought the output looked like a report?

 

[guihualinux]

The hide duplicates applies to REPORTING. You NEVER hide duplicates in a table, query, or form. Access is not Excel. When you have repeating data in a table, you almost always have a design problem. The repeating data belongs in a parent table and the specific data belongs in a child table with a reference to the parent. The reference field is called a foreign key (FK for short). The FK in the child table = the PK (primary key) of the parent table and that connects the two tables so you can pull the data together when you need to.

Ok understook, thank you bro

 

[Isaac]

Set Hide Duplicates to Yes in the detail line.

Good one