I've never used if/then statements, but I think I need to now. I've got a report returning competitor information, including national totals. I want to be able to compare their totals with our totals without showing information about our offices in the competitor cities. The report shows details for each competitor, but we just need our totals. I was thinking the statement might be something like If Competitor.City = EG.city then sum([EG.Revenue]). I have no clue if that's close to right syntax or not, or where even to put that...maybe in the report footer?
If Then's in report footer
- Thread starter cjordan8
- Start date
Similar threads
