Search results for query: *

Hi, I'm trying to use VBA in access to open an excel spreadsheet, replace some content, and copy to another spreadsheet. The repace code works fine in Excel, but if I put it in access, I got "Subscript out of range", Here is the code: Set oXL = CreateObject("Excel.Application")...

I have a table like: Table 1 POL-ID EFF-DATE TYP-IND I need to generate a report like : Week-Ending Type1 Type2 Type3 Type4 06Jul07 20 10 5 7 13Jul07 15 17 12 4 20Jul07 18 19 1 12 27Jul07 5 10 11 20 Total...

I have no problem do it on batch, use SQL to create a hold file. Anyway how to do it online? SQL DB2 SELECT A.POL_ID, A.CO_ID, A.CVG_NUM, B.CLI_ID, C.CLI_FIRST_NM, C.CLI_LAST_NM FROM TABLE1 A, TABLE2 B, TABLE3 C WHERE A.CO_ID = B.CO_ID AND...

have trouble to convert a batch report(MVS) to online format. In batch JCL I have 3 SQL hold files, it's running fine. I tried to convert it to online(so user can use web to get report instead of submit a JCL), it complains the SQL hold files...has following error 0 NUMBER OF RECORDS IN TABLE=...

Another Q. I need to joint two table together. It's one to multiple situation. I need to select one record based on some criteria, say for example, based on an effective day would be one to one, how could I do that? Another one, I need to accept PARM from client input, I need to format the...

Newbies to webfocus. I need to joint two table together. Table 1 K 05 key-01 k 05 key-02 k 05 key-03 05 data-01 05 data-02 05 data-03 05 data-04 Table 2 K 05 t2-key-01 K 05 t2-key-02 k 05 t2-key-03 k 05 t2-key-04 k 05 t2-key-05 05 t2-data-01 05...