Results 1 to 3 of 3
  1. #1
    indira is offline Novice
    Windows 7 Access 97
    Join Date
    Nov 2010
    Posts
    6

    Report error

    I have a complicated report which was created by someone else. When I am trying to download this report it gives an error - " Microsoft Jet Database engine does not recognize '[2]' as a valid name or expression" Can someone help me in solving this error?



    Thanks,
    Indira

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Hard to say without seeing it. That's the error a crosstab query would throw if its parameters weren't explicitly defined.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    indira is offline Novice
    Windows 7 Access 97
    Join Date
    Nov 2010
    Posts
    6
    Sorry for the late response. It got solved- I had to change a field.

    Thanks

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

Similar Threads

  1. Error in Footer Sum on Report
    By eww in forum Reports
    Replies: 2
    Last Post: 08-26-2010, 01:54 PM
  2. more than one table error in report mode
    By jonesy29847 in forum Reports
    Replies: 3
    Last Post: 07-19-2010, 01:11 PM
  3. Access Report Error
    By sneupane in forum Reports
    Replies: 1
    Last Post: 03-10-2010, 09:31 AM
  4. Error in Print Report Button
    By Robert M in forum Reports
    Replies: 16
    Last Post: 09-23-2009, 03:08 PM
  5. Report Printing Error
    By gjohnson71 in forum Reports
    Replies: 4
    Last Post: 03-07-2009, 12:36 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