Search results

screenshots I'm attaching two screenshots that will probably help to illustrate the problem I have. These two images present the query in two different versions, one version with fields Month, Channel, Airport taken out and therefore the sum of bookings is working fine, and another version...

Hi, No idea why this code doesn't work, it's getting me the following error: This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the...

filter No idea what was wrong, when I tried later to run the first filter By Date, if it stopped to work and was getting a pop up window telling me that it can't find the right Combo Box. I deleted this file, and started over once again. And this time it worked perfectly... I did exactly the...

filters Yes, I did. Look, let's have a look at it step by step: This is the filter query that I use in my macro in ApplyFilter command: SELECT * FROM (SELECT Comentarios.*, reservas.Hotel, reservas.Destino, reservas.Pais, reservas.Benef, reservas.Rentab, reservas.[Falta] FROM reservas LEFT...

filter It didn't work, I don't know why. The filter didn't work at all. But I resolved that problem in a different way: I saved the filter as a query and then I run it using a macro with ApplyFilter Command. But now I have another problem. I need another filter to filter out record by Person...

Hi, I have a small problem that I driving me mad and I can't progress with my work. I don't know why the following code doesn't work. When I execute it, there is simply no effect, no error message, nothing... Private Sub CuadroDateFilter_AfterUpdate() Me.Filter = "Falta=" & "#" &...