Hello
I have a crystal report with data from an Oracle database. I have created a query in MS Access in the exact same structure as the datasource from Oracle and need to do a union query.
How do I do that? I can use the "Add Command" but it throws me an error that it can't find the MS Access table (or vice versa when I add command from the Oracle datasource).
Is it do-able?
Thanks~
I have a crystal report with data from an Oracle database. I have created a query in MS Access in the exact same structure as the datasource from Oracle and need to do a union query.
How do I do that? I can use the "Add Command" but it throws me an error that it can't find the MS Access table (or vice versa when I add command from the Oracle datasource).
Is it do-able?
Thanks~