If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CIRCULAR REFERENCE CAUSED
WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I
GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? |
#2
|
|||
|
|||
Are you using an Alias for a field that is the same name as one of the
fields in the source table(s)? If so, see: http://support.microsoft.com/?id=97526 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Schuster" wrote in message ... WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? |
#3
|
|||
|
|||
I have checked all alias and no problem there. the strange thing is, only
when doing a export i get this message. Carl S. "Allen Browne" wrote in message ... Are you using an Alias for a field that is the same name as one of the fields in the source table(s)? If so, see: http://support.microsoft.com/?id=97526 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Schuster" wrote in message ... WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? |
#4
|
|||
|
|||
What kind of export? TransferText? TransferDatabase?
Does it involve an import/export spec? What kind name are you exporting to? Any possible issues with that? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carl Schuster" wrote in message ... I have checked all alias and no problem there. the strange thing is, only when doing a export i get this message. Carl S. "Allen Browne" wrote in message ... Are you using an Alias for a field that is the same name as one of the fields in the source table(s)? If so, see: http://support.microsoft.com/?id=97526 "Carl Schuster" wrote in message ... WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? |
#5
|
|||
|
|||
On Wed, 27 Oct 2004 12:57:54 -0300, "Carl Schuster"
wrote: WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? First off... please lay off the CAPS LOCK key. It's rude, it's hard to read, and it looks like you're SHOUTING AT US. Secondly... please crosspost rather than multiposting. If (and it's rare) you need to post to multiple newsgroups, put all the newsgroups in the Newsgroups line; this will help those of us who volunteer identify questions which have already been answered in another group. Finally... I'm sure I could fix the query, if I could see it. However I can't, and my telepathic interface is on the blink today. I have to assume that you have a query named QUERY_NAME which includes a reference to QUERY_NAME, so the query is calling itself. Could you open the query in SQL view and post the SQL code here (this one newsgroup please)? John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#6
|
|||
|
|||
Sorry for the capslock. when working I leave it on. Sorry.
Whe trying to do an export or putting it behind a report i get the circular reference caused error. When only running this crosstab query it works fine. here's the query: ============================== PARAMETERS [Forms]![SELECTED GENERAL DATA]![PROFIT MARGIN VERKOOPMIJ] Value, [Forms]![SELECTED GENERAL DATA]![DISTRIBUTION FEE] Value, [Forms]![SELECTED GENERAL DATA]![EXCHANGE RATE ASSUMPTION] Value, [Forms]![SELECTED GENERAL DATA]![TARIEF OMZET BELASTING] Value, [Forms]![SELECTED GENERAL DATA]![ACCIJNS] Value, [Forms]![SELECTED GENERAL DATA]![TARIEF ACCIJNS PER HECTOLITER] Value, [Forms]![SELECTED GENERAL DATA]![PRIJS LIST] Value, [Forms]![SELECTED GENERAL DATA]![BUDGET_VERSIE] Value, [Forms]![SELECTED GENERAL DATA]![BUDGET_JAAR] Value; TRANSFORM Sum(IIf([GENERIC_CODE]=0,[AANTAL]*(([TOT_COST]*Forms![SELECTED GENERAL DATA]![EXCHANGE RATE ASSUMPTION])+(Forms![SELECTED GENERAL DATA]!ACCIJNS/100)/(1+(Forms![SELECTED GENERAL DATA]!ACCIJNS/100))*((-Forms![SELECTED GENERAL DATA]![DISTRIBUTION FEE]*Forms![SELECTED GENERAL DATA]![EXCHANGE RATE ASSUMPTION])+([PRIJS]*(1-Forms![SELECTED GENERAL DATA]![PROFIT MARGIN VERKOOPMIJ]/100)))/(1+(Forms![SELECTED GENERAL DATA]![TARIEF OMZET BELASTING]/100))+(Forms![SELECTED GENERAL DATA]![TARIEF ACCIJNS PER HECTOLITER])),[AANTAL]*[TOT_COST]*Forms![SELECTED GENERAL DATA]![EXCHANGE RATE ASSUMPTION])) AS FBCCOST SELECT Q_COST_FVM_FORMULE.PROD_CODE, Q_COST_FVM_FORMULE.PROD_PRI_DESC, Q_COST_FVM_FORMULE.PACKAGE_DESC, Q_COST_FVM_FORMULE.BRAND_DESC, Q_COST_FVM_FORMULE.FRANCHISE_DESC, Sum([FBCCOST]) AS TOTAAL FROM Q_COST_FVM_FORMULE INNER JOIN Q_SELECTEDBUDGET ON Q_COST_FVM_FORMULE.PROD_CODE = Q_SELECTEDBUDGET.PRODCODE GROUP BY Q_COST_FVM_FORMULE.PROD_CODE, Q_COST_FVM_FORMULE.PROD_PRI_DESC, Q_COST_FVM_FORMULE.PACKAGE_DESC, Q_COST_FVM_FORMULE.BRAND_DESC, Q_COST_FVM_FORMULE.FRANCHISE_DESC PIVOT Q_SELECTEDBUDGET.WEEK; =================================== "John Vinson" wrote in message ... On Wed, 27 Oct 2004 12:57:54 -0300, "Carl Schuster" wrote: WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME"" ANYONE KNOW HOW TO FIX THIS? First off... please lay off the CAPS LOCK key. It's rude, it's hard to read, and it looks like you're SHOUTING AT US. Secondly... please crosspost rather than multiposting. If (and it's rare) you need to post to multiple newsgroups, put all the newsgroups in the Newsgroups line; this will help those of us who volunteer identify questions which have already been answered in another group. Finally... I'm sure I could fix the query, if I could see it. However I can't, and my telepathic interface is on the blink today. I have to assume that you have a query named QUERY_NAME which includes a reference to QUERY_NAME, so the query is calling itself. Could you open the query in SQL view and post the SQL code here (this one newsgroup please)? John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CIRCULAR REFERENCE CAUSED | Carl Schuster | General Discussion | 1 | October 28th, 2004 09:36 AM |
Circular Reference Override | Bob | Worksheet Functions | 1 | September 1st, 2004 08:54 PM |
Circular reference error - where ? | Lynn | Worksheet Functions | 1 | November 20th, 2003 03:05 PM |