The name of the field takes the name of its source query,

[jamal numan]

The name of the field takes the name of its source query,



I’m wondering why a field takes the name of its source query along with its name!

Please, have a look on the attached screenshot

How can I fix this problem?

Thank you

Best

Jamal

[Robeen]

Access does this when more than one data source has a field with the same name.
In your case, I cant see how you are arriving at 'CountOfRef_B' in your 'Water_Grouping2_Total'. Is there a field named 'Water' used to arrive at 'CountOfRef_B'?
Because both data sources [I'm guessing 'Water_Grouping2_Total' & 'Water_Grouping2_Count' are both queries since they have 'Count' fields . . . ??] in the WaterGrouping3 query are named starting with 'Water_Grouping2', I guess they both derive from the same source data [a Query?] - and that both use a field named 'Water'.

Again - because I can't see your two sources in design view, I am only guessing.

Hope this helps.

[jamal numan]

Access does this when more than one data source has a field with the same name.
In your case, I cant see how you are arriving at 'CountOfRef_B' in your 'Water_Grouping2_Total'. Is there a field named 'Water' used to arrive at 'CountOfRef_B'?
Because both data sources [I'm guessing 'Water_Grouping2_Total' & 'Water_Grouping2_Count' are both queries since they have 'Count' fields . . . ??] in the WaterGrouping3 query are named starting with 'Water_Grouping2', I guess they both derive from the same source data [a Query?] - and that both use a field named 'Water'.

Again - because I can't see your two sources in design view, I am only guessing.

Hope this helps.

Mann thanks Robeen for the help.

best

Jamal