Results 1 to 7 of 7
  1. #1
    RAJESHKUMAR R is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    48

    Microsoft Access Database Engine does not Recognize "[Forms]![MENU]![FR_DATE] as a valid Field name


    Dear Experts,

    I was using a Cross tab Query (SQL View - as below). It was working perfectly file till Now!

    Code:
    TRANSFORM Sum(ZVRR_TO_FR.CRD_Qty) AS SumOfQty
    SELECT ZVRR_TO_FR.Part_Number
    FROM ZVRR_TO_FR
    GROUP BY ZVRR_TO_FR.Part_Number
    PIVOT ZVRR_TO_FR.CRD_Month;


    Today I made few changes in sub query criteria Reference date from a Form Named as "MENU". After that I am subjected Error and could't able to proceed further. Kindly suggest me with a solutions!

    Regards,
    Rajeshkumar R

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    EVERY crosstab query, you MUST enter the path name of the criteria in the PARAMETERS.
    in query design, menu, parameters button,

    fill in the path, and the type of data
    [Forms]![MENU]![FR_DATE] , DATE TIME

    this doesnt have to be set in any query except crosstabs. for some reason they must have it.

  3. #3
    RAJESHKUMAR R is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    48
    Dear Rnman256,

    Thanks for your Response!

    I opened my Crosstab Query in Design View, But in Show/Hide tab; Parameters option is invisible!

    I tried link above suggestion with my SQL Query itself, But I am getting an Error as " syntax Error in Parameter clause"

    Code:
    PARAMETERS [Forms]![MENU]![FR_DATE],DATE TIME;
    TRANSFORM Sum(ZVRR_TO_FR.CRD_Qty) AS SumOfQty
    SELECT ZVRR_TO_FR.Part_Number
    FROM ZVRR_TO_FR
    GROUP BY ZVRR_TO_FR.Part_Number
    PIVOT ZVRR_TO_FR.CRD_Month;


    Thanks & Regards,
    Rajeshkumar R

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    The Date Time qualifier shouldn't have a space in it -
    PARAMETERS [Forms]![MENU]![FR_DATE], DateTime:
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Parameters option should NEVER be invisible.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Also there should not be a comma before datetime

  7. #7
    RAJESHKUMAR R is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    48
    Dear All,

    Thanks for all your inputs, I could able to Resolve my subjected Query!

    Thanks & Regards,
    Rajeshkumar R

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-24-2017, 09:32 AM
  2. Replies: 13
    Last Post: 05-03-2016, 08:44 AM
  3. Replies: 2
    Last Post: 02-01-2016, 08:27 AM
  4. Replies: 4
    Last Post: 05-22-2015, 02:29 AM
  5. Replies: 1
    Last Post: 05-06-2015, 03:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums