+ Reply to Thread
Results 1 to 2 of 2

Enter Parameter Value

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

    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.

    Please Login or Register  to view this content.
    Thanks in advance.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,938

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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.6.0 RC 1