Cross References

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to make a query with cross references just like excel does.
How can i do it?

I need a begining balance which has the endong balance in its formula, and i
need an ending balance that uses a begining balance in its formula.

Is anybody there to kno how to do this?

Thanks a lot, Lina
 
I want to be sure my question is clear, so I am going to explain it better.

I have a table with this data:

Company Product Year Month BeginingStock SalesQuantity
EndingStock

The beginingStock of one month is the EndingStock of the last month
and the Ending stock is a formula: BeginingStock * SalesQuantity.

This cause a circular reference in access.

How can i make this query so i do not get this error message?

Thanks a lot, Lina
 
Back
Top