Subforms Format

[bsdixon]

I was wondering if any one could help me with formating a subform. I want the form to print across in columns instead of down in rows. For example I want:

Customer Number: 456 457
Name: John Cindy

The only way I can get it to display is:

Customer Number Name
456 John
457 Cindy

Thanks.

 

[Rich]

Use a crosstab query and a report. The wizards will create both for you

 

[bsdixon]

I do not think that a cross tab query will work. It says that I have too many records.

I can set up my subform so that the column headings are along the left side like I want, but it only prints one column of data. The next record forms below with another set of headings instead of creating another column of data. Is there anyway to fix this?

Thanks.

 

[bsdixon]

I thought that it might help if I were more specific.

I am trying to create a form that has site location for a farmstead. This form has directions and other information about the site.

I then want to create a subform that lists the various grain bins at the site and their information. For example I want my subform to look like:

Bin #.........101........102....103
Diameter....15.........12.......20
Height........30.........25.......35
Capacity...3,000...2,000...5,500

I have one table with all of the site information and I have another table that lists every bin with its diameter, height, and capacity. The tables are linked by the site number.

Any help would be GREATLY appreciated.