0
votes
0answers
9 views

How can I create a SUM of an AVG Calculated Value in an MS-Access Report

I have an Access Report with: DEPT = Engineering Title = Systems Analyst FTEs = .8 Year = 1 I calculate the AVG[FTEs] in the group header. I need to calculate the SUM (AVG[FTEs]), but Access will ...
1
vote
1answer
44 views

MS Access - Totals in Report

I have constructed a database in Microsoft Access and have a report in which I want to include the number of alerts that relate to certain areas. If I wanted to include the number of alerts relating ...
0
votes
0answers
362 views

Why is MS Access Report repeating the details section?

I am using MS Access 2010, and I created a form that then produces a report. Because it is designed to print on a label instead of a regular piece of paper, the entire report is smaller than usual, ...
0
votes
1answer
221 views

Removing the second line of an address when it is null in an Access 2007 report?

I'm trying to use the CanShrink property in a report in Access 2007 so that if the mailingAddress2 field from my query is null or blank it will collapse the Address 2 field and move the mailingCity, ...