Frank Rocco
|
| Posted: 05/22/2001, 8:20 AM |
|
Hello,
I'm trying to group some records in codecharge and am getting invalid SQL
query, drive does not support requested properties.
I'm trying to connect to as AS/400.
does anyone have experience with connecting to an AS/400 using Codecharge?
Can you give me an example of the correct SQL syntax for grouping records in
a database?
Is version 2.0 of Codecharge going to be easier to connect to the AS/400?
I'm using Microsoft ODBC, I also have AS/400 OLE DB, but cannot get this to
work at all.
Thanks
Frank
|
|
|
 |
Malik
|
| Posted: 05/22/2001, 2:13 PM |
|
Hi Frank,
Can you tell how you are connecting to AS/400 via ODBC? Do you have IBM
iSeries at your disposal? If not then you might be using Client Access ...
Thanks.
Malik
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9ee03n$9d1$1@mail.tankhill.com...
> Hello,
>
> I'm trying to group some records in codecharge and am getting invalid SQL
> query, drive does not support requested properties.
>
> I'm trying to connect to as AS/400.
>
> does anyone have experience with connecting to an AS/400 using Codecharge?
>
> Can you give me an example of the correct SQL syntax for grouping records
in
> a database?
>
> Is version 2.0 of Codecharge going to be easier to connect to the AS/400?
>
> I'm using Microsoft ODBC, I also have AS/400 OLE DB, but cannot get this
to
> work at all.
>
> Thanks
> Frank
>
>
|
|
|
|
Frank Rocco
|
| Posted: 05/22/2001, 3:40 PM |
|
I'm using Client Access. There is an ODBC driver installed. There also is an
OLE DB driver, but I do not understand the syntax to connect using that.
I don't think CodeCharge can do what I am trying to do.
I want to select fields from a table and sum the amounts and print break
totals and a grand total.
Thanks for the help.
Frank
|
|
|
|
CodeCharge
|
| Posted: 05/22/2001, 10:23 PM |
|
As for the invalid SQL query, it doesn't look like a CodeCharge issue
because it is the response from your ODBC driver.
Possibly the query is wrong and cannot be executed, or ODBC driver cannot
process such query.
As for break totlas and grand total, you are correct, CodeCharge cannot be
used to create resports at this time.
You may try generating simple grid and then manually modify the code, or
create the report page outside of CodeCharge.
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9eepsd$vh3$1@mail.tankhill.com...
> I'm using Client Access. There is an ODBC driver installed. There also is
an
> OLE DB driver, but I do not understand the syntax to connect using that.
>
> I don't think CodeCharge can do what I am trying to do.
> I want to select fields from a table and sum the amounts and print break
> totals and a grand total.
>
> Thanks for the help.
> Frank
>
>
|
|
|
|
Jim Ryan
|
| Posted: 05/23/2001, 4:05 AM |
|
I to have tried to connect to the AS400 through an odbc connection in
CodeCharge without any luck. I got as far as connecting to the AS400 and
choosing the file but when it tried to get the fields it just locked up. I
read your email and it came to me. I haven't tried this with CodeCharge yet,
but I have done this with some Access programs I've built. When I get to
work today I to am going to try it..
Create a new Client Access odbc to point to the library where the file is
located. I've done this before with a file in the QGPL library. If you have
MS Access, go to file|get external data|link tables, in the dropdownlist for
"files of type" choose "odbc databases()" and choose your newly created
Client Access odbc. This will get you connected to the AS400. Choose the
file on the AS400 that you want to use.
Save the Database. Then in CodeCharge, point to the Access database as your
database. Give it a shot and let me know if it works. Like I said before, I
am going to try this today. I'll let you know how it turns out.
Jim
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9eepsd$vh3$1@mail.tankhill.com...
> I'm using Client Access. There is an ODBC driver installed. There also is
an
> OLE DB driver, but I do not understand the syntax to connect using that.
>
> I don't think CodeCharge can do what I am trying to do.
> I want to select fields from a table and sum the amounts and print break
> totals and a grand total.
>
> Thanks for the help.
> Frank
>
>
|
|
|
|
Malik
|
| Posted: 05/23/2001, 4:24 AM |
|
Sound good if it really work. I have similar assignment i.e. to access
AS/400 DB2 via client access and using ASP as middleware to manipulate data
on Web in real-time. Jim you would do traffic job if you succeed in your
proposed formula. Only concern left would be performance and integrity.
I am not sure if Frank Rocco is access DB2 on AS/400. In my case, I am
dealing with AS/400 with S21 as top layer.
Keep this topic running and I invite other Gurus to share their knowledge on
this issue.
Thanks to all.
Malik
Belgium
"Jim Ryan" <jryan@stratos.net> wrote in message
news:9eg5he$1d1$1@mail.tankhill.com...
> I to have tried to connect to the AS400 through an odbc connection in
> CodeCharge without any luck. I got as far as connecting to the AS400 and
> choosing the file but when it tried to get the fields it just locked up. I
> read your email and it came to me. I haven't tried this with CodeCharge
yet,
> but I have done this with some Access programs I've built. When I get to
> work today I to am going to try it..
> Create a new Client Access odbc to point to the library where the file is
> located. I've done this before with a file in the QGPL library. If you
have
> MS Access, go to file|get external data|link tables, in the dropdownlist
for
> "files of type" choose "odbc databases()" and choose your newly created
> Client Access odbc. This will get you connected to the AS400. Choose the
> file on the AS400 that you want to use.
> Save the Database. Then in CodeCharge, point to the Access database as
your
> database. Give it a shot and let me know if it works. Like I said before,
I
> am going to try this today. I'll let you know how it turns out.
>
> Jim
>
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9eepsd$vh3$1@mail.tankhill.com...
> > I'm using Client Access. There is an ODBC driver installed. There also
is
> an
> > OLE DB driver, but I do not understand the syntax to connect using that.
> >
> > I don't think CodeCharge can do what I am trying to do.
> > I want to select fields from a table and sum the amounts and print break
> > totals and a grand total.
> >
> > Thanks for the help.
> > Frank
> >
> >
>
>
|
|
|
|
Frank Rocco
|
| Posted: 05/23/2001, 4:26 AM |
|
Thanks for getting back to me.
Is this something planned for 2.0?
Should I get a report write like Crystal Reports?
Another thought I had was calling an ASP script that as hand coded from
within Codecharge.
Regards,
Frank
|
|
|
|
Jim Ryan
|
| Posted: 05/24/2001, 3:59 AM |
|
I did make the connection using my proposed formula but I had to use a SQL
statement (generated in Access under the queries tab) and copied it to the
CodeCharge|form properties|SQL to see the fields. CodeCharge wouldn't read
it as a table. Now the next problem is when I generated the code to the web
server, it wouldn't make the connection. I'm posting it to the same computer
that has the odbc I created to connect with. I only had a few minutes to
play with it today. I'll try a few other things and keep you all informed on
my progress.
To all AS400 users, I've been using a program called Compleo Explorer and
Compleo Supervisor, that will download reports in from the AS400. It has the
ability to import into Access among other formats. You may want to check it
out. I've been using it for about 4 months and probably saved a few hundred
trees :) http://www.symtrax.com
Jim
P.S.
Frank privately e-mailed me some code of how he connected to his AS400 using
the statement below. I thought others may be interested so here's the code.
Dim MyConn
Dim MyRs
Set MyConn = Server.CreateObject"ADODB.Connection")
Set MyRs = Server.CreateObject("ADODB.Recordset")
MyConn.Open "DSN=SPBXXXXX;UID=UUUUU;PWD=PPPP"
MySQL="Select * from table orrder by fld1, fld2"
Set MyRs=MyConn.Execute(MySQL)
"Malik" <n.malik@usa.net> wrote in message
news:9eg6m8$2fj$1@mail.tankhill.com...
> Sound good if it really work. I have similar assignment i.e. to access
> AS/400 DB2 via client access and using ASP as middleware to manipulate
data
> on Web in real-time. Jim you would do traffic job if you succeed in your
> proposed formula. Only concern left would be performance and integrity.
>
> I am not sure if Frank Rocco is access DB2 on AS/400. In my case, I am
> dealing with AS/400 with S21 as top layer.
>
> Keep this topic running and I invite other Gurus to share their knowledge
on
> this issue.
>
> Thanks to all.
>
> Malik
> Belgium
>
>
> "Jim Ryan" <jryan@stratos.net> wrote in message
>news:9eg5he$1d1$1@mail.tankhill.com...
> > I to have tried to connect to the AS400 through an odbc connection in
> > CodeCharge without any luck. I got as far as connecting to the AS400 and
> > choosing the file but when it tried to get the fields it just locked up.
I
> > read your email and it came to me. I haven't tried this with CodeCharge
> yet,
> > but I have done this with some Access programs I've built. When I get to
> > work today I to am going to try it..
> > Create a new Client Access odbc to point to the library where the file
is
> > located. I've done this before with a file in the QGPL library. If you
> have
> > MS Access, go to file|get external data|link tables, in the dropdownlist
> for
> > "files of type" choose "odbc databases()" and choose your newly created
> > Client Access odbc. This will get you connected to the AS400. Choose the
> > file on the AS400 that you want to use.
> > Save the Database. Then in CodeCharge, point to the Access database as
> your
> > database. Give it a shot and let me know if it works. Like I said
before,
> I
> > am going to try this today. I'll let you know how it turns out.
> >
> > Jim
> >
> >
> >
> > "Frank Rocco" <farocco@hotmail.com> wrote in message
> >news:9eepsd$vh3$1@mail.tankhill.com...
> > > I'm using Client Access. There is an ODBC driver installed. There also
> is
> > an
> > > OLE DB driver, but I do not understand the syntax to connect using
that.
> > >
> > > I don't think CodeCharge can do what I am trying to do.
> > > I want to select fields from a table and sum the amounts and print
break
> > > totals and a grand total.
> > >
> > > Thanks for the help.
> > > Frank
> > >
> > >
> >
> >
>
>
|
|
|
|
Malik
|
| Posted: 05/29/2001, 8:28 AM |
|
Hi Jim,
It is quite some time we never heard from you? If you are able to contact
AS/400 using CC?
You are doing great job man.
Malik
"Jim Ryan" <jryan@stratos.net> wrote in message
news:9eiphr$g89$1@mail.tankhill.com...
> I did make the connection using my proposed formula but I had to use a SQL
> statement (generated in Access under the queries tab) and copied it to the
> CodeCharge|form properties|SQL to see the fields. CodeCharge wouldn't read
> it as a table. Now the next problem is when I generated the code to the
web
> server, it wouldn't make the connection. I'm posting it to the same
computer
> that has the odbc I created to connect with. I only had a few minutes to
> play with it today. I'll try a few other things and keep you all informed
on
> my progress.
> To all AS400 users, I've been using a program called Compleo Explorer and
> Compleo Supervisor, that will download reports in from the AS400. It has
the
> ability to import into Access among other formats. You may want to check
it
> out. I've been using it for about 4 months and probably saved a few
hundred
> trees :) http://www.symtrax.com
>
> Jim
>
> P.S.
> Frank privately e-mailed me some code of how he connected to his AS400
using
> the statement below. I thought others may be interested so here's the
code.
>
> Dim MyConn
> Dim MyRs
> Set MyConn = Server.CreateObject"ADODB.Connection")
> Set MyRs = Server.CreateObject("ADODB.Recordset")
> MyConn.Open "DSN=SPBXXXXX;UID=UUUUU;PWD=PPPP"
> MySQL="Select * from table orrder by fld1, fld2"
> Set MyRs=MyConn.Execute(MySQL)
>
>
>
>
>
>
> "Malik" <n.malik@usa.net> wrote in message
>news:9eg6m8$2fj$1@mail.tankhill.com...
> > Sound good if it really work. I have similar assignment i.e. to access
> > AS/400 DB2 via client access and using ASP as middleware to manipulate
> data
> > on Web in real-time. Jim you would do traffic job if you succeed in your
> > proposed formula. Only concern left would be performance and integrity.
> >
> > I am not sure if Frank Rocco is access DB2 on AS/400. In my case, I am
> > dealing with AS/400 with S21 as top layer.
> >
> > Keep this topic running and I invite other Gurus to share their
knowledge
> on
> > this issue.
> >
> > Thanks to all.
> >
> > Malik
> > Belgium
> >
> >
> > "Jim Ryan" <jryan@stratos.net> wrote in message
> >news:9eg5he$1d1$1@mail.tankhill.com...
> > > I to have tried to connect to the AS400 through an odbc connection in
> > > CodeCharge without any luck. I got as far as connecting to the AS400
and
> > > choosing the file but when it tried to get the fields it just locked
up.
> I
> > > read your email and it came to me. I haven't tried this with
CodeCharge
> > yet,
> > > but I have done this with some Access programs I've built. When I get
to
> > > work today I to am going to try it..
> > > Create a new Client Access odbc to point to the library where the
file
> is
> > > located. I've done this before with a file in the QGPL library. If you
> > have
> > > MS Access, go to file|get external data|link tables, in the
dropdownlist
> > for
> > > "files of type" choose "odbc databases()" and choose your newly
created
> > > Client Access odbc. This will get you connected to the AS400. Choose
the
> > > file on the AS400 that you want to use.
> > > Save the Database. Then in CodeCharge, point to the Access database as
> > your
> > > database. Give it a shot and let me know if it works. Like I said
> before,
> > I
> > > am going to try this today. I'll let you know how it turns out.
> > >
> > > Jim
> > >
> > >
> > >
> > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > >news:9eepsd$vh3$1@mail.tankhill.com...
> > > > I'm using Client Access. There is an ODBC driver installed. There
also
> > is
> > > an
> > > > OLE DB driver, but I do not understand the syntax to connect using
> that.
> > > >
> > > > I don't think CodeCharge can do what I am trying to do.
> > > > I want to select fields from a table and sum the amounts and print
> break
> > > > totals and a grand total.
> > > >
> > > > Thanks for the help.
> > > > Frank
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Jim Ryan
|
| Posted: 05/30/2001, 4:01 AM |
|
Hi Malik,
I just got back into town Monday and I've been catching up on the list. At
work, we just bought another company and my priorities have changed for now.
If I get some time this week, I'll give it some more testing. I still have a
few more ideas to try out. I did connect to the 400 in Access and downloaded
it to a table then used CodeCharge to connect to the Access database. I
still want to try to use Compleo to automatically download the information
into Access. Also, we should research IBM's web site and maybe pick up more
information.
http://www-1.ibm.com/servers/eserver/iseries/clientaccess/cadev.htm
Have you or Frank had any success or ideas?
Jim
"Malik" <n.malik@usa.net> wrote in message
news:9f0f7l$39u$1@mail.tankhill.com...
> Hi Jim,
>
> It is quite some time we never heard from you? If you are able to contact
> AS/400 using CC?
>
> You are doing great job man.
>
> Malik
>
> "Jim Ryan" <jryan@stratos.net> wrote in message
>news:9eiphr$g89$1@mail.tankhill.com...
> > I did make the connection using my proposed formula but I had to use a
SQL
> > statement (generated in Access under the queries tab) and copied it to
the
> > CodeCharge|form properties|SQL to see the fields. CodeCharge wouldn't
read
> > it as a table. Now the next problem is when I generated the code to the
> web
> > server, it wouldn't make the connection. I'm posting it to the same
> computer
> > that has the odbc I created to connect with. I only had a few minutes to
> > play with it today. I'll try a few other things and keep you all
informed
> on
> > my progress.
> > To all AS400 users, I've been using a program called Compleo Explorer
and
> > Compleo Supervisor, that will download reports in from the AS400. It has
> the
> > ability to import into Access among other formats. You may want to check
> it
> > out. I've been using it for about 4 months and probably saved a few
> hundred
> > trees :) http://www.symtrax.com
> >
> > Jim
> >
> > P.S.
> > Frank privately e-mailed me some code of how he connected to his AS400
> using
> > the statement below. I thought others may be interested so here's the
> code.
> >
> > Dim MyConn
> > Dim MyRs
> > Set MyConn = Server.CreateObject"ADODB.Connection")
> > Set MyRs = Server.CreateObject("ADODB.Recordset")
> > MyConn.Open "DSN=SPBXXXXX;UID=UUUUU;PWD=PPPP"
> > MySQL="Select * from table orrder by fld1, fld2"
> > Set MyRs=MyConn.Execute(MySQL)
> >
> >
> >
> >
> >
> >
> > "Malik" <n.malik@usa.net> wrote in message
> >news:9eg6m8$2fj$1@mail.tankhill.com...
> > > Sound good if it really work. I have similar assignment i.e. to access
> > > AS/400 DB2 via client access and using ASP as middleware to manipulate
> > data
> > > on Web in real-time. Jim you would do traffic job if you succeed in
your
> > > proposed formula. Only concern left would be performance and
integrity.
> > >
> > > I am not sure if Frank Rocco is access DB2 on AS/400. In my case, I am
> > > dealing with AS/400 with S21 as top layer.
> > >
> > > Keep this topic running and I invite other Gurus to share their
> knowledge
> > on
> > > this issue.
> > >
> > > Thanks to all.
> > >
> > > Malik
> > > Belgium
> > >
> > >
> > > "Jim Ryan" <jryan@stratos.net> wrote in message
> > >news:9eg5he$1d1$1@mail.tankhill.com...
> > > > I to have tried to connect to the AS400 through an odbc connection
in
> > > > CodeCharge without any luck. I got as far as connecting to the AS400
> and
> > > > choosing the file but when it tried to get the fields it just locked
> up.
> > I
> > > > read your email and it came to me. I haven't tried this with
> CodeCharge
> > > yet,
> > > > but I have done this with some Access programs I've built. When I
get
> to
> > > > work today I to am going to try it..
> > > > Create a new Client Access odbc to point to the library where the
> file
> > is
> > > > located. I've done this before with a file in the QGPL library. If
you
> > > have
> > > > MS Access, go to file|get external data|link tables, in the
> dropdownlist
> > > for
> > > > "files of type" choose "odbc databases()" and choose your newly
> created
> > > > Client Access odbc. This will get you connected to the AS400. Choose
> the
> > > > file on the AS400 that you want to use.
> > > > Save the Database. Then in CodeCharge, point to the Access database
as
> > > your
> > > > database. Give it a shot and let me know if it works. Like I said
> > before,
> > > I
> > > > am going to try this today. I'll let you know how it turns out.
> > > >
> > > > Jim
> > > >
> > > >
> > > >
> > > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > > >news:9eepsd$vh3$1@mail.tankhill.com...
> > > > > I'm using Client Access. There is an ODBC driver installed. There
> also
> > > is
> > > > an
> > > > > OLE DB driver, but I do not understand the syntax to connect using
> > that.
> > > > >
> > > > > I don't think CodeCharge can do what I am trying to do.
> > > > > I want to select fields from a table and sum the amounts and print
> > break
> > > > > totals and a grand total.
> > > > >
> > > > > Thanks for the help.
> > > > > Frank
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Malik
|
| Posted: 06/20/2001, 2:29 PM |
|
Hi Jim,
I just want to check if you able to access AS/400 with ASP code generated by
CC? If it worked the way you proposed i.e. importing DB2 tables in to access
and then do CC auto ASP generation, and finally checking same code with
AS/400 ODBC?
Thanks I appreciate if you update me on this matter. I am suppose to do
similar job next week and really appreciate if you advise me proper way to
do it. I appreciate your time for this.
Malik
"Jim Ryan" <jryan@stratos.net> wrote in message
news:9f2jtm$tm5$1@mail.tankhill.com...
> Hi Malik,
> I just got back into town Monday and I've been catching up on the list. At
> work, we just bought another company and my priorities have changed for
now.
> If I get some time this week, I'll give it some more testing. I still have
a
> few more ideas to try out. I did connect to the 400 in Access and
downloaded
> it to a table then used CodeCharge to connect to the Access database. I
> still want to try to use Compleo to automatically download the information
> into Access. Also, we should research IBM's web site and maybe pick up
more
> information.
> http://www-1.ibm.com/servers/eserver/iseries/clientaccess/cadev.htm
> Have you or Frank had any success or ideas?
>
> Jim
>
>
> "Malik" <n.malik@usa.net> wrote in message
>news:9f0f7l$39u$1@mail.tankhill.com...
> > Hi Jim,
> >
> > It is quite some time we never heard from you? If you are able to
contact
> > AS/400 using CC?
> >
> > You are doing great job man.
> >
> > Malik
> >
> > "Jim Ryan" <jryan@stratos.net> wrote in message
> >news:9eiphr$g89$1@mail.tankhill.com...
> > > I did make the connection using my proposed formula but I had to use a
> SQL
> > > statement (generated in Access under the queries tab) and copied it to
> the
> > > CodeCharge|form properties|SQL to see the fields. CodeCharge wouldn't
> read
> > > it as a table. Now the next problem is when I generated the code to
the
> > web
> > > server, it wouldn't make the connection. I'm posting it to the same
> > computer
> > > that has the odbc I created to connect with. I only had a few minutes
to
> > > play with it today. I'll try a few other things and keep you all
> informed
> > on
> > > my progress.
> > > To all AS400 users, I've been using a program called Compleo Explorer
> and
> > > Compleo Supervisor, that will download reports in from the AS400. It
has
> > the
> > > ability to import into Access among other formats. You may want to
check
> > it
> > > out. I've been using it for about 4 months and probably saved a few
> > hundred
> > > trees :) http://www.symtrax.com
> > >
> > > Jim
> > >
> > > P.S.
> > > Frank privately e-mailed me some code of how he connected to his AS400
> > using
> > > the statement below. I thought others may be interested so here's the
> > code.
> > >
> > > Dim MyConn
> > > Dim MyRs
> > > Set MyConn = Server.CreateObject"ADODB.Connection")
> > > Set MyRs = Server.CreateObject("ADODB.Recordset")
> > > MyConn.Open "DSN=SPBXXXXX;UID=UUUUU;PWD=PPPP"
> > > MySQL="Select * from table orrder by fld1, fld2"
> > > Set MyRs=MyConn.Execute(MySQL)
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Malik" <n.malik@usa.net> wrote in message
> > >news:9eg6m8$2fj$1@mail.tankhill.com...
> > > > Sound good if it really work. I have similar assignment i.e. to
access
> > > > AS/400 DB2 via client access and using ASP as middleware to
manipulate
> > > data
> > > > on Web in real-time. Jim you would do traffic job if you succeed in
> your
> > > > proposed formula. Only concern left would be performance and
> integrity.
> > > >
> > > > I am not sure if Frank Rocco is access DB2 on AS/400. In my case, I
am
> > > > dealing with AS/400 with S21 as top layer.
> > > >
> > > > Keep this topic running and I invite other Gurus to share their
> > knowledge
> > > on
> > > > this issue.
> > > >
> > > > Thanks to all.
> > > >
> > > > Malik
> > > > Belgium
> > > >
> > > >
> > > > "Jim Ryan" <jryan@stratos.net> wrote in message
> > > >news:9eg5he$1d1$1@mail.tankhill.com...
> > > > > I to have tried to connect to the AS400 through an odbc connection
> in
> > > > > CodeCharge without any luck. I got as far as connecting to the
AS400
> > and
> > > > > choosing the file but when it tried to get the fields it just
locked
> > up.
> > > I
> > > > > read your email and it came to me. I haven't tried this with
> > CodeCharge
> > > > yet,
> > > > > but I have done this with some Access programs I've built. When I
> get
> > to
> > > > > work today I to am going to try it..
> > > > > Create a new Client Access odbc to point to the library where the
> > file
> > > is
> > > > > located. I've done this before with a file in the QGPL library. If
> you
> > > > have
> > > > > MS Access, go to file|get external data|link tables, in the
> > dropdownlist
> > > > for
> > > > > "files of type" choose "odbc databases()" and choose your newly
> > created
> > > > > Client Access odbc. This will get you connected to the AS400.
Choose
> > the
> > > > > file on the AS400 that you want to use.
> > > > > Save the Database. Then in CodeCharge, point to the Access
database
> as
> > > > your
> > > > > database. Give it a shot and let me know if it works. Like I said
> > > before,
> > > > I
> > > > > am going to try this today. I'll let you know how it turns out.
> > > > >
> > > > > Jim
> > > > >
> > > > >
> > > > >
> > > > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > > > >news:9eepsd$vh3$1@mail.tankhill.com...
> > > > > > I'm using Client Access. There is an ODBC driver installed.
There
> > also
> > > > is
> > > > > an
> > > > > > OLE DB driver, but I do not understand the syntax to connect
using
> > > that.
> > > > > >
> > > > > > I don't think CodeCharge can do what I am trying to do.
> > > > > > I want to select fields from a table and sum the amounts and
print
> > > break
> > > > > > totals and a grand total.
> > > > > >
> > > > > > Thanks for the help.
> > > > > > Frank
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
