Recent content by vasque01

Hi, So I have checked several fields and it appears that there is only one which is not working. I have a query named "New Maf Query" which contains data about the screenings we have conducted in the past three years. What I want is to create a field where it says how many screenings we...

HI, So the intetnion of this part is to agregate data. Perhaps better if I show the whole expression: SELECT Count(IIf(([New Maf Query].[Quarter Screening Conducted] Like "*2018*") And ([New Maf Query].[Week Screening Conducted]="25"),1)) AS [Screening conducted Week 25], Count(IIf([New Maf...

Hi, I just updated some columns in my tables and now one of my queries is not working. However, the columns which are used in this query were not updated or changed in any way. When I want to go to Datasheet view I get an error message: "Reserved error (-3087);there is no message for this...

Hi, I used this one: IIf([Partner Channel] Is Null,"",IIf([Partner Channel]="Agent" Or [Partner Channel]="Agents","Yes", IIf([Partner Group]="Consumer","No",IIf([Partner Group]="OEM","No",IIf([Partner Channel]="B2B" And [Partner type]="Professional Trade (Project Partner)","No",IIf([Partner...

Hi, It works now, thank you so much!

Hi Everyone, I am trying to build an expression in my Access database. At the moment I have the one bellow, but when I want to save it I get an error message saying that the "expression has a fundtion containing the wrong number of arguments", does anyone has a suggestion, or maybe can spot...