W
WildlyHarry
I have an access database that is set to extract data from an oracle
database. The oracle db houses records entered by users through a web based
application. Currently the end user has the option to click multiple text
boxes and/or enter values in the web based application. The record appears
in the oracle db as a seperate record for every action, regardless as to
whether or not was done for the same case. Additionally if a user clicks a
text box there is a description of what they clicked, but no data. If they
enter data, there is description and the data they entered. However, they
appear as different records in the database even though they have the same
case id. So when I run my pass through query, my data comes in as multiple
records for the same case id, with different data based on the users actions.
It some cases no data, just a tag. I need to be able to take data from the
fields where it exists and populate the fields where there is no data. Is
there a formula that will look for all similar cased ids and allow me to use
nested ifs to move my data around based on set rules? See the example below.
Thanks in advance for your help.
Case ID Tag Data Desc
1 LA_AMT_RETURND RTN
1 LA_Amt_Held $500.00 HLD
2 LA_AMT_RETURND $200.00 RTN
2 LA_Amt_Held HLD
3 LA_AMT_held $200.00 HLD
3 LA_AMT_RETURND $900.00 RTN
In these cases I need to change my output to what you see below for
calculations and reporting.
Case ID Tag Data Desc Tag1 Data1
Desc1
1 LA_AMT_RETURND $500.00 RTN LA_Amt_Held $500.00 HLD
2 LA_AMT_RETURND $200.00 RTN LA_Amt_Held $200.00 HLD
3 LA_AMT_held $200.00 HLD LA_AMT_RETURND $900.00 RTN
I have tried using a cross tab query but there are 38 different tags. It
causes my queries to be too large.
database. The oracle db houses records entered by users through a web based
application. Currently the end user has the option to click multiple text
boxes and/or enter values in the web based application. The record appears
in the oracle db as a seperate record for every action, regardless as to
whether or not was done for the same case. Additionally if a user clicks a
text box there is a description of what they clicked, but no data. If they
enter data, there is description and the data they entered. However, they
appear as different records in the database even though they have the same
case id. So when I run my pass through query, my data comes in as multiple
records for the same case id, with different data based on the users actions.
It some cases no data, just a tag. I need to be able to take data from the
fields where it exists and populate the fields where there is no data. Is
there a formula that will look for all similar cased ids and allow me to use
nested ifs to move my data around based on set rules? See the example below.
Thanks in advance for your help.
Case ID Tag Data Desc
1 LA_AMT_RETURND RTN
1 LA_Amt_Held $500.00 HLD
2 LA_AMT_RETURND $200.00 RTN
2 LA_Amt_Held HLD
3 LA_AMT_held $200.00 HLD
3 LA_AMT_RETURND $900.00 RTN
In these cases I need to change my output to what you see below for
calculations and reporting.
Case ID Tag Data Desc Tag1 Data1
Desc1
1 LA_AMT_RETURND $500.00 RTN LA_Amt_Held $500.00 HLD
2 LA_AMT_RETURND $200.00 RTN LA_Amt_Held $200.00 HLD
3 LA_AMT_held $200.00 HLD LA_AMT_RETURND $900.00 RTN
I have tried using a cross tab query but there are 38 different tags. It
causes my queries to be too large.