Access 365 - Query - Duplicate Unique Values in query output - how to resolve please

[SpywareDr]

Access included as part of Microsoft 365 and Office 365 subscriptions

[pankajunk]

Access included as part of Microsoft 365 and Office 365 subscriptions

This is where Microsoft's Office 365 language gets really confusing. Yes, you can still buy Access Desktop using the Office 365 subscription model. However, when people say Access 365, they often also mean an online version of Access, which Microsoft used to offer as part of the Office 365 for Business suite, called Access Web Apps.

However, Microsoft retired that in 2018 - https://www.hyperoffice.com/blog/201...ted-june-2018/