Solved Dcount not working

[CJ_London]

would it be possible for someone to make the changes and then reupload the file

It works for me if you put
=dlookup("[Auftrag]","[Tasks]","[Status]='Offen'") in the Text2 controlsource.

If you are still having problems, upload the file again with what you are trying rather than leaving things blank - otherwise we don't know what you are doing wrong and can only repeat what we have been saying

what other way could i use to get the same result as a "lookup field"? possible?

use it in a form combo or listbox - just not in the table

 

[OnePoint Consulting]

After quite a bit of facepalming, i noticed that in the german version (for some reason) commas are not allowed, and we use semi-colons instead… after i switched out all the commas and added the correct function which was DomAnzahl (Dcount), I finally got it to work. The final funtcion was:

=DomAnzahl("[Auftrag]";"[Tasks]";"[Status]='Offen'")

A BIG thank you to everyone that helped and i'm sorry for causing any mild frustrations =)

Hope you all have a great day!


Best regards

 

[CJ_London]

glad you got it resolved

 

[moke123]

After quite a bit of facepalming, i noticed that in the german version (for some reason) commas are not allowed, and we use semi-colons instead…

If it's any consolation, dont feel bad. We've seen that situation before and someone was bound to recognize it sooner or later.

Congrats for finding it on your own.