I am trying to format a field to force it to have leading zero's.
RecordCount: Format([RecordCount]), "0000000")
However, this gives me "Circular reference caused by alias 'RecordCoun' in query definitions select list.
Is there a way to avoid using a different name. I can make it work by using
RecordCount: Format([RecordCountF]), "0000000")
or
RecordCountF: Format([RecordCount]), "0000000")
But then I have to go in and change a bunch of other queries and modules that are using this query.
Is there a way to force it to use 7 digits without changing the field name?