+ Reply to Thread
Results 1 to 3 of 3

Access Query- perameter box wont go away & calculation fields issues #NUM

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    185

    Access Query- perameter box wont go away & calculation fields issues #NUM

    Owners'IncomeQuery:

    I need to get rid of this paramret box as it is not supposed to be there. I have searched online videos and cant get rid of it.
    I just need a caluclated field - Income: [Price Per Day]*[Rental End Date]-[Rental Start Date], the results are coming up with #NUM

    same thing with TopCustomers

    Same thing with TopGrossingVehicles
    I wrote:
    Gross Income:
    Please Login or Register  to view this content.
    , but it is not giving me the grand total, just price per day.

    same thing with:
    CustomerRentalSummaryforRprt

    Once the parameter values get fixed in Owners'IncomeQuery & CustomerRentalSummaryforRprt, that will fix the data for both reports.

    I have a dummy test I been working on to try and perfect it, attached.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2501 Win 11
    Posts
    24,434

    Re: Access Query- perameter box wont go away & calculation fields issues #NUM

    To remove the IDate Parameter, change your Calculated field to read

    Please Login or Register  to view this content.
    You currently have the the IDate in that expression and Access does not recognize it as a valid field so it throws up the parameter box.

    Where is GDate field located? Calculated? Don't see this field anywhere except in the query. That is why it is giving you a parameter box.
    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

  3. #3
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    185

    Re: Access Query- perameter box wont go away & calculation fields issues #NUM

    I was just missing those () brackets. Works like a charm! thx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Access Query Wont Display In Excel
    By directing_dude1 in forum Access Tables & Databases
    Replies: 3
    Last Post: 04-03-2019, 11:08 AM
  2. Import Data from Access Query with Calculated Fields
    By PicoTTS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2016, 04:52 PM
  3. Connection Issues, Excel To Access Query, Access 2010
    By onechief in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2015, 07:09 PM
  4. Access Query with Calculated Fields Not seen by Excel
    By Xcelguy in forum Access Tables & Databases
    Replies: 12
    Last Post: 11-06-2013, 05:34 PM
  5. Export Access Query Record into decicated fields in a Excel Template File
    By JRayhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2013, 04:38 PM
  6. Replies: 1
    Last Post: 10-19-2012, 02:08 PM
  7. [SOLVED] Help: pivot chart data in secured Access database wont show fields
    By A C in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-24-2006, 09:30 PM

Tags for this Thread

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