Results 1 to 2 of 2
  1. 04-02-2013, 08:10 PM #1
    rncarterjm
    rncarterjm is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    9

    Circular reference caused by


    Can someone please help me understand why I am getting error "Circular reference caused by 'standings' " I get this error when I try to run the query "standings" I have a similar JOIN in "qrySubStanding" with no error. See attached....
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 04-02-2013, 08:59 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    The query selects from itself. It needs to be another table or query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to solve error 3828 caused by using a multivalued field & parameters in query?
    By lookingforK in forum Import/Export Data
    Replies: 3
    Last Post: 03-13-2013, 04:00 PM
  2. need running sum in the same field(circular)
    By brown1 in forum Access
    Replies: 3
    Last Post: 11-01-2012, 12:55 PM
  3. Circular Reference using UCase(), Following a Video Tutorial
    By Modify_inc in forum Access
    Replies: 6
    Last Post: 08-10-2012, 09:30 AM
  4. Expression builder error, circular reference
    By cowboy in forum Programming
    Replies: 3
    Last Post: 07-15-2010, 12:55 PM
  5. mutiuser automatic updates events caused
    By skbrede in forum Access
    Replies: 4
    Last Post: 07-26-2009, 09:22 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums