Access nubie
Registered User.
- Local time
- Today, 16:20
- Joined
- Oct 24, 2008
- Messages
- 14
We have an Access db with linked tables to oracle. I'm looking for code that will loop the below query and substitute the number 10 (the criteria) in the first line with each region (about 60 of them) listed in a table in the database and append the results to a table. Any help is appreciated.
where
((((O851DM.GL_ORGZN.EXPNG_CTR_Reg_NUM)='10') and
((O851DM.JSL_FINSTS.NET_FUNC_CURR_AMT)<>0) and
((O851DM.GL_TIME_PERIOD.ACCTG_PERIOD_DT_TXT) like 'SEP-13%')))
where
((((O851DM.GL_ORGZN.EXPNG_CTR_Reg_NUM)='10') and
((O851DM.JSL_FINSTS.NET_FUNC_CURR_AMT)<>0) and
((O851DM.GL_TIME_PERIOD.ACCTG_PERIOD_DT_TXT) like 'SEP-13%')))
Last edited by a moderator:
