DBApprentice
On Error GoTo AWF *****:
- Local time
- Today, 09:37
- Joined
- Dec 24, 2018
- Messages
- 150
Hi,
I am trying to build a query that collects some information and export it to Excel. But since many values from the DB is coming from cascading Combobox.
During the tests I noticed when I run the query it is duplicating the entries, i.e. I have just 4 records, but when I simply include the tables on the Query Designer and run it is repeating the records to show each of the cascading combo values.
Any ideas to help me to build this query? :banghead:
PS: DB is attached and the query is qryExportFullCardsXls, the cascading are PillarFK and PillarElements among others.
I am trying to build a query that collects some information and export it to Excel. But since many values from the DB is coming from cascading Combobox.
During the tests I noticed when I run the query it is duplicating the entries, i.e. I have just 4 records, but when I simply include the tables on the Query Designer and run it is repeating the records to show each of the cascading combo values.
Any ideas to help me to build this query? :banghead:
PS: DB is attached and the query is qryExportFullCardsXls, the cascading are PillarFK and PillarElements among others.