Recent content by motherof2

Good Morning!! The 2 sub-report idea worked!! Thank you!! I have another issue with this same report since I used the sub reports. Within the main report, I have used criteria to filter between check dates for a specific employee. When I put the criteria in the main report, it does filter to...

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...

Thank you so much for your responses!!!! Here is what I have tried and here were the results: 1) I took out the quotes and the comma around the 60000, the sum calculation still did not pick up this number. It is still picking up the original salary amount. 2) I tried adding the CCur to see...

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...