IIF problem In query - HELP

[Guest]

I have fieldname COMMISSION that store all the commission from year 2005 and
2006

Im creating a report so i made a query comparing Commission in year 2005 and
2006 on the left side of my rerport shows the 2005 Commission it works and
the right side of my report is 2006 commission but its not showing. I put
this query

expr1:IIf([year]=2005,[Commission],"")
expr2:IIf([year]=2006,[Commission],"")

in query its shows all the 2006 commission but on report its not showing

pls. help, I really appreciate a lot

 

[Baz]

I have fieldname COMMISSION that store all the commission from year 2005 and
2006

Im creating a report so i made a query comparing Commission in year 2005 and
2006 on the left side of my rerport shows the 2005 Commission it works and
the right side of my report is 2006 commission but its not showing. I put
this query

expr1:IIf([year]=2005,[Commission],"")
expr2:IIf([year]=2006,[Commission],"")

in query its shows all the 2006 commission but on report its not showing

pls. help, I really appreciate a lot

For a starter I would suggest changing the column aliases to something more
meaningful than expr1 and expr2 (say, commission_2005 and commission_2006),
and then in your report make sure that the text boxes are bound to the
correct fields using those names (look at the Control Source property on
each text box).