Forms Display (rows in columns and colums in Rows)

[Zdz16]

Hi Expert;

Be forgiving to a beginner;

Generally, in forms display continuous, data are presented in columns and each row corresponds to a record.
Is it possible to do the opposite? I.e. each column presents a record and each row a data.
The goal is to create a form that displays data for differents periods. For example like this

Period 2013/10 | 2013/11 | 2013/12 | ...
Quantity 10 | 45 | 75 | ...
Value 120 | 455 | 145 |...

This corresponds to a table whose structure is
Period
Quantity
Value

Best regard

[rpeare]

yes, it's called a crosstab query, but you will not be able to edit your data in that format.

[Zdz16]

yes, it's called a crosstab query, but you will not be able to edit your data in that format.

Thank you for the reply;

I'll see this side for more informations

B.R.

[MarvinM]

Z,

Here are a few good tutorials to get you started:
http://www.brighthub.com/computing/w...les/23497.aspx
http://www.keystonelearning.com/reso...rosstab_query/
http://www.lynda.com/Access-tutorial...6/73382-4.html
http://www.datapigtechnologies.com/f.../crosstab.html

HTH,
MarvinM

[Zdz16]

Z,

Here are a few good tutorials to get you started:
http://www.brighthub.com/computing/w...les/23497.aspx
http://www.keystonelearning.com/reso...rosstab_query/
http://www.lynda.com/Access-tutorial...6/73382-4.html
http://www.datapigtechnologies.com/f.../crosstab.html

HTH,
MarvinM

Hi Marvin

Thank you very much for this information that will help me to better understand and use this type of query

Kind regards