User Profile

Collapse

Profile Sidebar

Collapse
Corey
Corey
Last Activity: Apr 24 '07, 01:21 PM
Joined: Nov 2 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Corey
    started a topic Decode grouping error
    in Oracle

    Decode grouping error

    hello,

    I’m trying to run a query and I’m getting error messages
    Can anyone help me get though this problem?

    1: Tried this and got this error message
    ORA-00923

    , decode (grouping(dsd.F ield1,'RETURNED ', COUNT(*), 0)) Net1
    , decode (grouping(dsd.f ield1,'COMPLETE D', COUNT(*), 0)) Net2

    2: Tried this and got this error message
    ORA-00909

    , decode (grouping(dsd.F ield1,'RETURNED ',...
    See more | Go to post
    • Corey
      started a topic Oracle back-end MS-Access 2003 client front-end
      in Access

      Oracle back-end MS-Access 2003 client front-end

      Hello everyone. The company I’m working for is looking to convert my MS database into a Oracle database.
      Can anyone tell me the advantages and disadvantages of a Oracle back-end with a MS-Access 2003 client front-end

      Thanks

      Corey
      See more | Go to post
      • Corey
        started a topic Convert SQL to MS Access
        in Access

        Convert SQL to MS Access

        Hello everyone

        Can anyone help me convert the sql statement below to a statement I can put into Microsoft access, or help me brake this down so I can put it into access.

        Thanks
        Corey


        Code:
         select 'FOX' PLATFORM
       ,dsd.site_id store_id
       ,dsd.locale
       --, x.site_name Store_Name
       , to_char(dsd.reporting_date,'DD') DD
       , to_char(dsd.reporting_date,'MM')
        ...
        See more | Go to post
        Last edited by MMcCarthy; Feb 3 '07, 03:23 AM. Reason: code tags
        • Corey
          started a topic How can I Speed Up My Queries
          in Access

          How can I Speed Up My Queries

          Hello everyone.

          I'm looking for ways that I can speed up my database, mostly the queries that I download from the Oracle ODBC.

          Thank you

          Corey
          See more | Go to post
          • Corey
            replied to Would this Be an IIF Statement or?
            in Access
            A: Look in the Program ID Field "From tblProgramActBy Day Table"
            B: if the Program ID Field = 1667100 "From tblProgramActBy Day Table"

            C: Go to the table tblProgramByPro ductByDay

            ---- In that table look for the criteria---

            The Field Program ID must = 0 "From tblProgramByPro ductByDay Table"
            The Field Product ID must = 38648800 "From tblProgramByPro ductByDay...
            See more | Go to post

              Leave a comment:

            • Corey
              started a topic Would this Be an IIF Statement or?
              in Access

              Would this Be an IIF Statement or?

              Hi again everyone,

              I'm new to VBA but willing to try

              I have two tables that my query is looking at.

              1. tblProgramActBy Day
              And the other is:
              2. tblProgramByPro ductByDay

              I’m trying to tell the query to
              A: Look in the Program ID Field
              B: if the Program ID Field = 1667100
              C: Go to the table tblProgramByPro ductByDay

              ---- In that table look...
              See more | Go to post
              No activity results to display
              Show More
              Working...