CIRCULAR REFERENCE CAUSED

[Carl Schuster]

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?

 

[Allen Browne]

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]

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]

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?

 

[John Vinson]

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

 

[Carl Schuster]

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;
===================================