V
Vass
can the group help please.
I have a database query, bringing in 2 databases linked by a single primary
key (in both db's)
however, when they are brought into excel, they appear linked fine accross
the columns however
every record is duplicated
So I have 2 rows for each item, with the same data
How do I remove the duplication, within the query rather that use
conditional formatting or some other method after
refreshing the worksheet?
Many thanks in advance.
I have a database query, bringing in 2 databases linked by a single primary
key (in both db's)
however, when they are brought into excel, they appear linked fine accross
the columns however
every record is duplicated
So I have 2 rows for each item, with the same data
How do I remove the duplication, within the query rather that use
conditional formatting or some other method after
refreshing the worksheet?
Many thanks in advance.