Creating a multi-column Form

[devGarfield]

Hello All,

I have a table that holds data for overnight uploads, it has 3 fields. I would like to display this information in a form, but I want the data to be displayed like a multi-column report. E.g.

**** Column 1 ***** | ***** Column 2 ****
123155 12/06/2003 Y | 134540 13/02/2004 Y
213990 11/07/2003 N | 233391 12/01/2004 N
124451 16/04/2003 N | 823435 09/05/2003 Y
203970 10/04/2003 Y |

The data is to be loaded Down then Across.

Any suggestions what so ever will be greatly appreciated.

 

[ZmrAbdulla]

Hi,
May be tricky, still a solution...
If it won't go more than 3 column then you can create a crosstab query with 3 Row headings. Use the this query as the RecordSource of a continues form. Select only the Row Heading fields from the query.

Regards


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[devGarfield]

Hi Zameer,

I tried to create the cross-tab query as suggested but I can't get it to work at all. It seems to want to process the data as a pivot table, which in this case is not want I want. I just want to display the data in columns in the form.

I've created a 3 column report showing the data as I want it, can I take this report and use it as a sub-report in the form? Or is these something else I can try?


Regards

Garfield

 

[ZmrAbdulla]

Hi,
You can't put report/subreport on a form.!!!!!
What if you are uising a continues form ?

It is time to leave now.. let me try it tomorrow...

Regards


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com