Access Feedback - Max() function in Polish query design view doesn't work

Question

Accesss 2016. I don't know where to post this information.

It is called "Maksimum". Access displays message:

Nie zdefiniowana funkcja "Maksimum" w wyrażeniu.

(= undefinied function "Max" in the expression)

All other functions work -Suma (=Sum), Średnia (=Avg), Minimum(=Min) etc. When Access is switched to English, Max() works.

Answer 1

What happens if you enter "Max" instead of "Maksimum" in the query grid when the language is set to Polish? It should automatically translate to Polish. Maybe there is some spelling issue.

Matthias Kläy, Kläy Computing AG

Answer 2

"Maximum" is in the combobox, not "Max". It is impossible to enter manually "Max" in the txt field of this combobox, because it takes names only from its list. But if

Wyr1: Max([Field Name])
(=Expr1: Max([Field Name])

is entered manually to the Pole (=Field, not to the text field of the combobox), the query works. However

Wyr1: Maksimum([Field Name])

is getting replaced by

Wyr1: [Field Name]

and "Maximum" selected in the combo (what doesn't work).

This is apparent bug, but I didn't know where to post this information and posted to this forum.

Answer 3

At one place you write "Maksimum", at the other "Maximum". What is the spelling in the Combobox?

In the version that doesn't work, can you switch to SQL view and post the SQL here?

I don't know of an official place to submit bugs in Access, but one of the Microsoft moderators should pick up on this and pass it along.

Matthias Kläy, Kläy Computing AG

Answer 4

The spelling is Maksimum and it doesnt work.

Polish wit "Max" manually entered in the Pole (=Field) or English with "Max" manually entered in the Field or selected in the combo box:

SELECT [Table Name].[Field Name], Max([Table Name].[Field Name]) AS MaxOf[Field Name]
FROM [Table Name]
GROUP BY [Table Name].[Field Name];

Polish with "Maksimum" selected in the combo box:

SELECT [Table Name].[Field Name], Maksimum([Table Name].[Field Name]) AS MaksimumOf[Field Name]
FROM [Table Name]
GROUP BY [Table Name].[Field Name];

So it doesn't translate Maksimum to Max.

Answer 5

Ok, I agree with you that this is a bug in Access. Luckily, you have a workaround. As said above, I hope that one of the Microsoft operators picks up this issue.

Matthias Kläy, Kläy Computing AG

Answer 6

Hi DK,

Do you have the same issue in other machine with Access 2016 installed?

Regards

Starain

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 7

I have only one computer.  Access was installed from Polish version of AccessRetail 2016 EN.img, however later was installed English language pack from setuplanguagepack.x86.en-us_.exe. I use English settings in Access options, but sometimes switch to Polish.
Maybe setuplanguagepack.x86.en-us_.exe spoiled something ?

Answer 8

Hi DK,

Could you repair your Office and try again?

Regards

Starain

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 9

What do you mean repair ? I won't reinstall Access, don't have time. This is a bug.

Answer 10

Hi.

If the same issue persist in other machine, it is may a bug.

Answer 11

Today I have noticed, that it is fixed.