Hi, I have been using Access for some time and have pretty much avoided errors, but this one has been keeping me busy for over an hour. Basically, I get the #name? error in only one of my reports although all of them use the same control source? I swear it worked a week ago. I attached the file, but keep in mind that most of the file is not in English. I get the error in "Pirkumi_laika_periodā" report. When you click on it it will ask you for the starting date (set it to 01.01.2000) and the end date (set it to 05.05.2020). "="Kopā par: " & [Uzvārds]" means "Total for: & surname". I know it's hard to follow, but I really need some help on this one.
izdevumi_2020.accdb.zip