Share via

Query Calculation - Adding two Fields with the same name

Anonymous
2017-09-12T13:56:54+00:00

I attempted to add a simple formula in a query, however, the two Field Names pulled from other queries have the identical "SUMofQuantity" name and therefore I am receiving an error message stating that there are more than one fields with that name so it is unable to distinguish which one I am looking for. Could you please assist in a way around this error? Thank you in advance for any help.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2017-09-12T14:00:36+00:00

Rather than for example SUMofQuantity + SUMofQuantity, use

Table1!SUMofQuantity + Table2!SUMofQuantity

That disambiguates it.

(of course you replace my object names with yours)

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest