G
Gerard Hofman
I am working on a cross tab query, based on two tables.
I would like it to show all the fields of table 1 as the
column heading and all the fields of table 2 as the row
heading, even if there is no data involved. It does not
seem to work as it is only showing those fields that have
data. Is there may be another way to do this? Or a way to
do it with a cross tab query. The reason I want it to
show all data is for transferring the query results to a
spreadsheet.
Thank you for your help
I would like it to show all the fields of table 1 as the
column heading and all the fields of table 2 as the row
heading, even if there is no data involved. It does not
seem to work as it is only showing those fields that have
data. Is there may be another way to do this? Or a way to
do it with a cross tab query. The reason I want it to
show all data is for transferring the query results to a
spreadsheet.
Thank you for your help