Robin-
It sounds like when the first column fills up, there's not enough room at the bottom of the page to put the report footer after the second column. Try making the report footer a bit taller or slightly change the size of the detail section.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Dec 11, 2016, at 11:36 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Thanks again John,
The detail section is above the page footer. "Force New Page" is 'None' and "New Row" is 'None'.
Robin
At 11/12/2016 08:49 PM, you wrote:
Robin-
And what are the settings for the section above the page footer?
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)
On Dec 11, 2016, at 12:35 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:
Thanks for the help John.
"What are the settings for the Force New Page and New Row?" - Each is showing 'None'.
"Column properties of the Report Footer? " - I cannot find an entry for 'Column Properties".
"And what are those settings for the section just before the Report Footer?" The section before the Report Footer is the Page Footer which is not used.
Cheers.
Robin
At 10/12/2016 11:13 PM, you wrote:
Robin-
What are the settings for the Force New Page and New Row or Column properties of the Report Footer? And what are those settings for the section just before the Report Footer?
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)
On Dec 10, 2016, at 12:03 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:
I am using Access 2013. I have a two column report and I need to show
the count of records at the end. If I put the count in the report
footer the total appears at the end of a column on the final page if
the first column on the page is not full. If the report runs to use
the secong column the total appears on a new page by itself.
What have I done wrong?
Many thanks,
Robin Chapple
------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au >
------------------------------------
------------------------------------
Yahoo Groups Links
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar