Table lay out

  • Thread starter Thread starter rahmad
  • Start date Start date
R

rahmad

Hi All,
is it possible to change table lay out or data sheet lay out.
Usually is like this
Month Qty In Qtyout Stoc
Jan 5 3 2

become like this
Month Jan
Qty in 5
Qty out 3
Stock 2

Thank's
 
Hi All,
is it possible to change table lay out or data sheet lay out.
Usually is like this
Month Qty In Qtyout Stoc
Jan 5 3 2

become like this
Month Jan
Qty in 5
Qty out 3
Stock 2

Thank's
Click to expand...

Sure. Use a Form or a Report. Lay out the textboxes wherever you like.

Tables are NOT designed for data display or printing; they're designed
for data storage. To display data, use a Form; to print data, use a
Report.

John W. Vinson [MVP]
 
Hi rahmad,

Yes, use a continuous form with the form in "form view" so that you can
place the fields where you want them.

Damian.
 
Thank's for the respon
But actually here is my problem.I'm creating a form and report with a chart.
The chart will display the data yearly.So,there will be 12 months or 12
records
will be displayed.And actuallly there still another field in each record (
about 12 fields
totally ).And I want to insert a subform under my chart that will look like
a datasheet
of the chart.That's way I asked .
Or Would somebody suggest me a better way to do that?.
 
Base your form or report on a crosstab query.

Thank's for the respon
But actually here is my problem.I'm creating a form and report with a chart.
The chart will display the data yearly.So,there will be 12 months or 12
records
will be displayed.And actuallly there still another field in each record (
about 12 fields
totally ).And I want to insert a subform under my chart that will look like
a datasheet
of the chart.That's way I asked .
Or Would somebody suggest me a better way to do that?.
Click to expand...
 
And I want to insert a subform under my chart that will look like
a datasheet
of the chart.That's way I asked .
Click to expand...

Use a Continuous Form or a listbox instead of a datasheet. Access
defaults to making subforms Datasheets, but you can change that
default.

John W. Vinson [MVP]
 
Sorry for keep asking,
If I specified 'Month' as column heading of my crosstab query
and 'QtyIn','QtyOut',and 'Stock' as the row heading
which fields tha should be specified as a value.

Your help much appreciated.
 
Back
Top