Search results

Thanks to everyone for taking time out of their day to help me! I really appreciate it! I will close this thread now.

Yeah. But when I fixed that problem, others occurred. Hopefully, I can figure this out. Thanks for the help!

I'll try doing it this way too. Thank you very much!!

The error message was 'this control has a reference to itself'. Yes, that's the problem I'm encountering.

Thanks anyway! But I did try switching the semicolons for commas and it gave me that syntax error. So I reckon it's definitely a regional thing.

I changed the name of the control, as suggested by @Minty and it turned out that that was the error being reported by the yellow triangle. But then, probably because it couldn't find the [durata] field anywhere when I ran the report, it asked me to insert a value for that field. I then tried to...

=Switch([durata]=120;"Durata e de doua ore";[durata]=90;"Obisnuit";[durata]>120;"Doua serii";[durata]<120;"Doua serii") There it is.

I did all the things you suggested, but it still won't work. It doesn't give me the syntax-related error anymore(that was definitely because of the stray '), but when I run the report, it still returns the message "#Type!". The last column is the one I used that function for. This is the way I...

Hello. I am trying to make a report (from a movie list) in which, according to the length (in minutes) of the movie, Access displays a text message in my report. I tried using an iif function but to no avail. I then decided to turn to a switch function, but I kept on getting the following error...