two separate data sources, no subreport link, list alphabetically

[hsandwick]

How do I list items alphabetically from two separate data sources (one is oracle 7, the second is Access, there will be others, too)? It's not possible to link the data, as only some results in A will equal some results in B and I need to show all in each.


Thanks!

Helen

 

[synapsevampire]

Link (not import) the Oracle data source into the Access database and then do a Union Query. Access is an appropriate tool for this.

-k

 

[hsandwick]

Thanks, synapsevampire, I'll try this.

 

[hsandwick]

synapsevampire,
How is this possible? My oracle database is on another server outside our scope; I have to pass through a firewall to access it. Would you please explain how to link this db to the access db? The oracle is the main db, the access is secondary.
Tks, Helen