zmbd -
Thanks for your responses. I KNOW that I was not hallucinating. I starting writing code on an Apple II computer (serial # <2000) in my dorm room in college in the Fall of 1979. While I don't hold myself out to be an "expert" programmer, I can usually figure it out and make it happen.
Between Saturday and Wednesday I went back to previously saved versions of the Access reports in my backup archives...
smills
Last Activity: Apr 28 '14, 12:35 AM
Joined: Apr 20 '14
Location:
-
I let Windows 7 do its usual "Updates" and guess what, the sums in the footers are displaying again.
Thank you Bill Gates. Please let me know where I can send my bill for four lost days.Leave a comment:
-
Screen shots
Let's try this again. Screen shots as jpgs. Is this within accepted protocol?
PrintPreview is as desired. Note that the ReportView displays the text box, but not the total. If I click on the text box the correct total will display, but only for the text box selected. When there are multiple test boxes in the Report Footer, each on must be individually clicked. That's not an option, but perhaps it gives...Leave a comment:
-
Files and Screen shots
Two zip files attached. One contains a Word doc with screen shots.
Second contains a VERY simple DB with one table and one report, which was the source of the screen shots above.
Maybe this is an issue on my computer?
Thanks. Appreciate the support. This seems SO simple but is has run me into a dead end....Leave a comment:
-
Thanks. Per your suggestion I expanded the text box width to 3", more than sufficient to display 132. There are no subreports. Got the same result.
This must be a quirk of my system. I'm running Office 2010 on Windows 7 on a Dell. If it were a common issue there would be a plethora of Google advice on the issue.
To make sure it isn't something in the database I've been working with, I went into Northwind and created...Leave a comment:
-
The Control Source and Name are the same in the Detail Section so I can't miss.
I just created a sample report using the Report Wizard WITH totals in the Report Footer. I get the same thing. In Print Preview the totals display perfectly. In Report View the totals in the Report Footer do not display unless I mouse click in the text box area for each total.Leave a comment:
-
Thanks for the response. My problem is VERY simple. Following your advice I created a new report using the Wizard. I put one Field called cfooLaneMiles (which is a Number, Double Type) in the Detail section and did a Report View. It works fine, listing 44 correctly as the value of that field in the three records in the table.
I then copied the field (Text Box) from the Detail section to the Report Footer section and surrounded...Last edited by zmbd; Apr 21 '14, 01:18 AM.Leave a comment:
-
Access Report Footer - =sum(xxxxxx) won't display in Report View
Access 2010
I have a Report Footer that sums fields displayed in the Detail section. In Report View, the detail items display correctly but the sums in the Report Footer shows 0 unless I click on the individual control in the Footer and the total will display. In Print Preview mode the totals in the Report Footer display correctly.
This has to be simple, but I've exhausted different options in the properties boxes,...
No activity results to display
Leave a comment: