Circular Reference Error

Can anyone see what would be causing me to get a circular reference error??? 
Thanks!

SELECT [BartS1Report].Customer_ID, [BartS1Report].Customer, 
[BartS1Report].Service_Address, [BartS1Report].Employee, 
[BartS1Report].Manager, [BartS1Report].Type_of_System, 
[BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
[BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
[BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
[BartS1Report].Range_4, [BartS1Report].Range_5, ((SELECT Sum([XX].[ZZZ]) FROM 
[BartS1Report] AS [XX] WHERE  [BartS1Report].Customer_ID & 
[BartS1Report].Customer & [BartS1Report].Service_Address & 
[BartS1Report].Employee & [BartS1Report].Manager & 
[BartS1Report].Type_of_System & [BartS1Report].Raw_Water & 
[BartS1Report].Treated_Water & [BartS1Report].Cycles 
& [BartS1Report].Inhibitor_Level & [BartS1Report].Range_1 & 
[BartS1Report].Range_2 & [BartS1Report].Range_3 & [BartS1Report].Range_4 & 
[BartS1Report].Range_5 >=  [XX].Customer_ID & [XX].Customer & 
[XX].Service_Address & [XX].Employee & [XX].Manager & [XX].Type_of_System & 
[XX].Raw_Water & [XX].Treated_Water & [XX].Cycles & [XX].Inhibitor_Level & 
[XX].Range_1 & [XX].Range_2 & [XX].Range_3 & [XX].Range_4 & 
[XX].Range_5)\20)+1 AS Record_Count
FROM BartS1Report
ORDER BY [BartS1Report].Customer_ID, [BartS1Report].Customer, 
[BartS1Report].Service_Address, [BartS1Report].Employee, 
[BartS1Report].Manager, [BartS1Report].Type_of_System, 
[BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
[BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
[BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
[BartS1Report].Range_4, [BartS1Report].Range_5;

0
Utf
2/23/2010 6:59:01 PM
access.reports 4434 articles. 0 followers. Follow

3 Replies
1050 Views

Similar Articles

[PageSpeed] 43

Do you have a field ZZZ in BartS1Report? It seems really different from your 
other field names. Is BartS1Report actually a table or is it a query? 

-- 
Duane Hookom
Microsoft Access MVP


"Tia" wrote:

> Can anyone see what would be causing me to get a circular reference error??? 
> Thanks!
> 
> SELECT [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> [BartS1Report].Service_Address, [BartS1Report].Employee, 
> [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> [BartS1Report].Range_4, [BartS1Report].Range_5, ((SELECT Sum([XX].[ZZZ]) FROM 
> [BartS1Report] AS [XX] WHERE  [BartS1Report].Customer_ID & 
> [BartS1Report].Customer & [BartS1Report].Service_Address & 
> [BartS1Report].Employee & [BartS1Report].Manager & 
> [BartS1Report].Type_of_System & [BartS1Report].Raw_Water & 
> [BartS1Report].Treated_Water & [BartS1Report].Cycles 
> & [BartS1Report].Inhibitor_Level & [BartS1Report].Range_1 & 
> [BartS1Report].Range_2 & [BartS1Report].Range_3 & [BartS1Report].Range_4 & 
> [BartS1Report].Range_5 >=  [XX].Customer_ID & [XX].Customer & 
> [XX].Service_Address & [XX].Employee & [XX].Manager & [XX].Type_of_System & 
> [XX].Raw_Water & [XX].Treated_Water & [XX].Cycles & [XX].Inhibitor_Level & 
> [XX].Range_1 & [XX].Range_2 & [XX].Range_3 & [XX].Range_4 & 
> [XX].Range_5)\20)+1 AS Record_Count
> FROM BartS1Report
> ORDER BY [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> [BartS1Report].Service_Address, [BartS1Report].Employee, 
> [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> [BartS1Report].Range_4, [BartS1Report].Range_5;
> 
0
Utf
2/24/2010 12:58:01 AM
BartS1Report is a Query that takes information from a bunch of tables.  It 
was suggested that I add the field ZZZ to it to count my records so that I 
only have 20 displayed per report and place remaining records on a new 
report.  The query, BartS1Report, is the data source for a report called 
BartS1Report.


"Duane Hookom" wrote:

> Do you have a field ZZZ in BartS1Report? It seems really different from your 
> other field names. Is BartS1Report actually a table or is it a query? 
> 
> -- 
> Duane Hookom
> Microsoft Access MVP
> 
> 
> "Tia" wrote:
> 
> > Can anyone see what would be causing me to get a circular reference error??? 
> > Thanks!
> > 
> > SELECT [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> > [BartS1Report].Service_Address, [BartS1Report].Employee, 
> > [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> > [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> > [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> > [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> > [BartS1Report].Range_4, [BartS1Report].Range_5, ((SELECT Sum([XX].[ZZZ]) FROM 
> > [BartS1Report] AS [XX] WHERE  [BartS1Report].Customer_ID & 
> > [BartS1Report].Customer & [BartS1Report].Service_Address & 
> > [BartS1Report].Employee & [BartS1Report].Manager & 
> > [BartS1Report].Type_of_System & [BartS1Report].Raw_Water & 
> > [BartS1Report].Treated_Water & [BartS1Report].Cycles 
> > & [BartS1Report].Inhibitor_Level & [BartS1Report].Range_1 & 
> > [BartS1Report].Range_2 & [BartS1Report].Range_3 & [BartS1Report].Range_4 & 
> > [BartS1Report].Range_5 >=  [XX].Customer_ID & [XX].Customer & 
> > [XX].Service_Address & [XX].Employee & [XX].Manager & [XX].Type_of_System & 
> > [XX].Raw_Water & [XX].Treated_Water & [XX].Cycles & [XX].Inhibitor_Level & 
> > [XX].Range_1 & [XX].Range_2 & [XX].Range_3 & [XX].Range_4 & 
> > [XX].Range_5)\20)+1 AS Record_Count
> > FROM BartS1Report
> > ORDER BY [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> > [BartS1Report].Service_Address, [BartS1Report].Employee, 
> > [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> > [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> > [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> > [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> > [BartS1Report].Range_4, [BartS1Report].Range_5;
> > 
0
Utf
3/2/2010 6:42:10 PM
I would just start removing fields/columns until the error went away. The 
last thing you removed would then be the culprit.

-- 
Duane Hookom
Microsoft Access MVP


"Tia" wrote:

> BartS1Report is a Query that takes information from a bunch of tables.  It 
> was suggested that I add the field ZZZ to it to count my records so that I 
> only have 20 displayed per report and place remaining records on a new 
> report.  The query, BartS1Report, is the data source for a report called 
> BartS1Report.
> 
> 
> "Duane Hookom" wrote:
> 
> > Do you have a field ZZZ in BartS1Report? It seems really different from your 
> > other field names. Is BartS1Report actually a table or is it a query? 
> > 
> > -- 
> > Duane Hookom
> > Microsoft Access MVP
> > 
> > 
> > "Tia" wrote:
> > 
> > > Can anyone see what would be causing me to get a circular reference error??? 
> > > Thanks!
> > > 
> > > SELECT [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> > > [BartS1Report].Service_Address, [BartS1Report].Employee, 
> > > [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> > > [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> > > [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> > > [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> > > [BartS1Report].Range_4, [BartS1Report].Range_5, ((SELECT Sum([XX].[ZZZ]) FROM 
> > > [BartS1Report] AS [XX] WHERE  [BartS1Report].Customer_ID & 
> > > [BartS1Report].Customer & [BartS1Report].Service_Address & 
> > > [BartS1Report].Employee & [BartS1Report].Manager & 
> > > [BartS1Report].Type_of_System & [BartS1Report].Raw_Water & 
> > > [BartS1Report].Treated_Water & [BartS1Report].Cycles 
> > > & [BartS1Report].Inhibitor_Level & [BartS1Report].Range_1 & 
> > > [BartS1Report].Range_2 & [BartS1Report].Range_3 & [BartS1Report].Range_4 & 
> > > [BartS1Report].Range_5 >=  [XX].Customer_ID & [XX].Customer & 
> > > [XX].Service_Address & [XX].Employee & [XX].Manager & [XX].Type_of_System & 
> > > [XX].Raw_Water & [XX].Treated_Water & [XX].Cycles & [XX].Inhibitor_Level & 
> > > [XX].Range_1 & [XX].Range_2 & [XX].Range_3 & [XX].Range_4 & 
> > > [XX].Range_5)\20)+1 AS Record_Count
> > > FROM BartS1Report
> > > ORDER BY [BartS1Report].Customer_ID, [BartS1Report].Customer, 
> > > [BartS1Report].Service_Address, [BartS1Report].Employee, 
> > > [BartS1Report].Manager, [BartS1Report].Type_of_System, 
> > > [BartS1Report].Raw_Water, [BartS1Report].Treated_Water, 
> > > [BartS1Report].Cycles, [BartS1Report].Inhibitor_Level, 
> > > [BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3, 
> > > [BartS1Report].Range_4, [BartS1Report].Range_5;
> > > 
0
Utf
3/2/2010 10:36:05 PM
Reply:

Similar Artilces: