Results 1 to 2 of 2
  1. #1
    suverman is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    15

    SQL*Plus code in MsAccess, how to modify?

    set pagesize 1000
    break on off_code skip 1


    compute sum label 'Sum of Off_code' of amount on ba
    nk
    select off_code, pay_dt, che_dt, che_no, count_no, bank, sum(amount) from paymast where off_code in (3123402, 3123600, 3123500, 3123200, 3123103, 3123000, 3123300, 3123101,3123102) and pay_dt = '&pay_dt' and che_no is not null and count_no not in (41, 91, 92, 62, 70) and che_no not in (0) group by off_code, count_no, pay_dt, che_dt, che_no, bank



    Can I know how to implement this in Ms Access, specially the first 3 lines.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    No, SQLPlus is a separate Oracle product.

    You could write MS Access queries and connect to Oracle via ODBC to link the Oracle tables. You could also do passthrough queries from Access to Oracle. But, I do not think you can "talk to SQLPlus" through Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Learn MSAccess by playing MSAccess Jeopardy
    By pkstormy in forum Sample Databases
    Replies: 4
    Last Post: 11-17-2016, 07:27 AM
  2. Modify sample templates?
    By DavesBonnyLass in forum Database Design
    Replies: 19
    Last Post: 05-26-2013, 03:16 AM
  3. Word code in Access - How to modify my current code
    By Alexandre Cote in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:26 AM
  4. Modify PivotChart Filter VBA
    By Catch Wrestler in forum Programming
    Replies: 1
    Last Post: 06-28-2010, 06:10 PM
  5. Import and Modify data
    By crownedzero in forum Forms
    Replies: 7
    Last Post: 06-16-2009, 11:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums