help with report

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I would like to create a report that goes like:

Table FieldA FieldB
Data A1 B1
A2 B2
A3 B3

Report:
FieldA
A1
A2
A3
FieldB
B1
B2
B3

Tried diffrent ways but could not achive it. Help appreciated.
Thanks in advance

Richard
 
I would like to create a report that goes like:
Table FieldA FieldB
Data A1 B1
A2 B2
A3 B3

Report:
FieldA
A1
A2
A3
FieldB
B1
B2
B3
Click to expand...
Make this select query:

SELECT FieldA FROM MyTable
UNION
SELECT FieldB FROM MyTable

then base your report on it.
 
Hi Mike

Thanks for the tip, If there are more than 2 fields, will I be able to do
it? I will be trying it out now.

Thanks again
Richard
 
Hi Mike

Manage to get it with more fileds, how would I put in the field titles in
the report. Now it groups them together.

Thank again

Richard
 
Back
Top