MS Access 2007 querying Linked table

K

Krish

I have linked a Product Master Table written in IBM/Universe using Universe/ODBC. I am able to perform lots of queries and forms in MS ACCESS . The linked table has a field called UM (Units of Measure) and the UM field has mutivalue fields stored as shown below.

CS 1
EA 16

The first and second lines are not consistently in the same order, because of selling practice. MS Access when queried for the field containing multivalue looks only for the first line. However in the native Universe database, retrieve (aka query) shows the results like this
PMID UM F64
40021 CS 1
EA 16
As you observe PMID does not get repeated for EA.

I am looking to see the query results like this
PMID UM F64
40021 CS 1
40021 EA 16
40023 EA 9
40023 CS 1

Any help is very much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format DATETIME to Date in query on linked table 5
Querying table based on conditions of entries in linked table 1
Linked Table Manager in ACCESS 4
Append query for MS Access 2003 table linked to a Sharepoint listwith lookup fields 0
UPdate SQL Table Access 2007 6
Print a list of tables in MS Access 2007 2
#NUM! Error in linked table (excel) 1
Append data to linked SQL Server 2008 table 0

Top