+ Reply to Thread
Results 1 to 2 of 2

Thread: Enter Parameter Value

  1. #1
    Valued Forum Contributor
    Join Date
    06-16-2008
    Posts
    252

    Enter Parameter Value

    Hi, i have written the following query in access which gives me an "Enter Parameter Value" Popup for SumOfWorkload and SumOfNumber Of OM. Can anybody help me understand why this is.

    SELECT [13WeeksData].GM, [13WeeksData].[Friendly Queue Name], Sum([13WeeksData].[Number Of OM]) AS [SumOfNumber Of OM], Sum([13WeeksData].Workload) AS SumOfWorkload, [13WeeksData].[Week Start Date], ([SumOfWorkload]/[SumOfNumber Of OM]) AS AHT INTO 13WeeksData_GM_Table
    FROM 13WeeksData
    GROUP BY [13WeeksData].GM, [13WeeksData].[Friendly Queue Name], [13WeeksData].[Week Start Date], ([SumOfWorkload]/[SumOfNumber Of OM])
    ORDER BY [13WeeksData].GM;
    Thanks in advance.

  2. #2
    Valued Forum Contributor alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Lake County, Illinois
    MS-Off Ver
    MS Office 2010, 2007 and 2002
    Posts
    1,161

    Re: Enter Parameter Value

    To fix this you must create a second query based upon the first query. Delete the calculated expression "Sum of Workload/Sum of Numbers of OM" in the first query.

    Put this calculation expression in the second query. Run the second query and you should be ok as it will draw the data directly from the first query. You do not need to run the first query as it will be prompted by the second query.

    This (parameter request) occurs because you have a calculation of aggregated fields and Access doesn't like this.

    Hope this helps you out.

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0