Odata contains fields from multiple tables in single table with different field names - for same

[Lidias13]

Hello,

New to forum, and new or rather back to some database stuff.
And sort of things I used to find easy it seems now baffle me due to neglect (

I have an odata source that has been published to me containing what is multiple tables with a single table in common.

This results in the single table being occupied consistently.
However all the rest of the data is "stepped".

So instead of having it all normalised into one field (where is the same data for different assets, which means they have output it as separate fields

IE ASSET_CODE/B1_RISK/E1_RISK

In Xthousands recorda Asset Code and B1_RISK is occupied
The for the next Xthousand records Asset Code and E1 is occupied
How do I go about getting Asset_Code and Risk(Normalizing B1_Risk and E1_Risk) so that the SAME field is occupied in an output table?
Be aware there is about 30+ fields for each "table" they have done this with.
And about 16 tables. =(

Help! Please )

Lidias13

 

[dhookom]

Hi Lidias13 and welcome to tek-tips.

Can we assume you would like to normalize a table with repeating groups of fields? If this is the case you can use a union query. For specific assistance, we would need some actual table and field names.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016