I have a report that I am trying to build using 2 crosstab queries. Here is a little insight on the situation: Within the report, I need to include hours and dollars as well as gross and net pay for particular employees. I am unable to find one table that will give me all of the results that...
I have been really stumped on this issue.....
I need to take salary amounts and cap them at $60,000 (for anyone who earns above that). So, I have used an IIf Statement that looks like this:
=IIf([report salary]>=60000,"$60,000",[report salary])
However, my dilema is that I also...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.