User Profile

Collapse

Profile Sidebar

Collapse
bilal1234567
bilal1234567
Last Activity: Mar 23 '12, 01:08 PM
Joined: Mar 21 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bilal1234567
    replied to Access Query of a Table
    in Access
    Actual Table Name is ExpectedRevenue

    I have the following Query and when I run, I get the following error.

    Code:
    SELECT [Project_ID], 'January' AS [Month], [January] 
FROM   [ExpectedRevenue] 
  
UNION ALL;
    Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'

    I am using Access 2007. I am not sure what I am missing.

    Thanks,
    See more | Go to post
    Last edited by NeoPa; Mar 23 '12, 12:33 AM. Reason: Added mandatory [CODE] tags for you

      Leave a comment:

    • bilal1234567
      replied to Access Query of a Table
      in Access
      Can you give the exact query for one record and i will duplicate for the rest. I am still learning and am getting error messages.

      Thanks
      See more | Go to post

        Leave a comment:

      • bilal1234567
        started a topic Access Query of a Table
        in Access

        Access Query of a Table

        I have an access table in the following format:
        Project_ID January February March .......
        1 $1000 $2000 $1500
        2 $0 $150 $345
        3 $500 $600 $250
        .
        .
        .

        I want to have the data in the following format:
        Project_ID Month Revenue
        1 January $1000
        1 February $2000
        1 March $1500...
        See more | Go to post
        No activity results to display
        Show More
        Working...