A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting Up & Running Reports Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
# of subreports in 1 main report? by Gabe
Is there a limit to the amount of subreports you can put in 1 main report? I'm using Access 2003. I have like 92 subreports I need in 1 report...or maybe I'm...
January 15th, 2010 08:52 PM
by Clifford Bass via AccessMonster.com Go to last post
1 138
# soft number of columns by Vsn
Hi, How can i set the number of columns I would like to use, in VBA at the, i suppose, Report_Open event? Thx, Ludovic
December 9th, 2006 07:42 AM
by Vsn Go to last post
2 118
September 2nd, 2009 12:09 AM
by Gina Whipp Go to last post
3 137
#Deleted - what does this mean by mark_jm via AccessMonster.com
I have a table, one of the fields is a memo field. For some reason it has become non updateable and contains the text #Deleted Your changes can not be made...
December 30th, 2008 03:08 PM
by mark_jm via AccessMonster.com Go to last post
2 123
#Div/0! Error by J
I have the formula: =(Sum(++))/(Sum())/100 and when I run the report I get "#Div/0!" appearing where I placed the formula. When i run the report for a...
March 28th, 2006 04:12 PM
by Duane Hookom Go to last post
2 95
#Error by JohnLute
I have a text box with this source:=!!!+!!! How can I revise this so that the text box will properly display if one of the fields is null? Currently, the...
November 8th, 2007 04:04 PM
by Duane Hookom Go to last post
4 156
#Error by Doc Rock
I'm getting a #Error when I try to print the result of a query. Sometimes the result () is "" and sometimes "D". I'm using =IIf(IsNull(),"ch",) but this...
February 19th, 2007 05:00 AM
by Doc Rock Go to last post
4 90
#error by ielmrani via AccessMonster.com
Hi, I can't understand why I am getting the following error: #error in a report, I am trying to show null if column = zero. Like...
February 2nd, 2007 09:58 PM
by ielmrani via AccessMonster.com Go to last post
2 94
#error by mac
Hello, I have a report that has over 200 pages. The lookup is the same for each one,ex: =IIf(NZ(DLookUp("","AG Single Acct Summary","=Parent! And...
November 22nd, 2005 11:40 AM
by Jon Ley Go to last post
1 106
#Error by JohnLute
I'm re-designing my reports to be a little more clean. I'm using the trick Duane Hookom suggested: convert labels to text boxes and use the control source to...
(Multi-page thread 1 2)
August 22nd, 2005 06:56 PM
by JohnLute Go to last post
15 270
#Error by Tina
I have a report based on a crosstab query. I added a text field to the detail section of the report that does the following: =Nz(DSum("","tbl_Invoices","...
March 18th, 2005 08:54 PM
by Ken Snell [MVP] Go to last post
5 129
#error by mmap
Generated a report using 'design wizard'. The report reference one of our tables only. When the field references one of the fields in the table things are ok...
April 27th, 2005 05:21 PM
by mmap Go to last post
2 98
#error by Stefan
I am calculating a field which totals the sum of a report(Charges) and a subreport(payments). It works fine when there is data in the payment. I get and...
June 5th, 2005 09:21 PM
by Steve Schapel Go to last post
2 86
#Error & #Name? by TomH
Hi I can not figure out how too get ot of a simple problem: In a footer of a report I have a formula in a text box that work ok when there are values to...
February 6th, 2006 03:11 PM
by BruceM Go to last post
5 75
#ERROR - but query fine by leahf via AccessMonster.com
I have want to print labels. When the query is run all the fields (name, address, city, zip) are fine. When I run the actual report that prints the label,...
March 10th, 2008 01:03 PM
by leahf via AccessMonster.com Go to last post
3 58
#error and #name? by confused
Hiya I am getting #error and #name? errors on my report. If anyone could help me out with either of these I would really appreciate it. Details are...
September 13th, 2004 06:40 PM
by Fons Ponsioen Go to last post
2 95
#error and a report by Joe C
Hello all, I have two questions. What does the "#error" error mean? In Access 07 I have a report that, when print previewed, gives me the #error in the...
August 30th, 2007 04:56 PM
by Joe C Go to last post
0 84
#Error and Zero Value Help by Whitney
I have a query with the following equation AVG Hold Time: /. Some fields show #error or a zero value (0:00:00). On a report footer I would like to average the...
February 28th, 2008 09:31 PM
by Duane Hookom Go to last post
1 85
#Error Count by JT
I have a query which converts a date format from YYYYMMDD to MM/DD/YYYY. When there is no date, the query returns a blank. When I use this query in my...
February 13th, 2009 04:03 PM
by John Spencer Go to last post
2 93
#error due to blank report by MARK RAUCH
I have a billing report that uses totals for the month. If there is no billing the report is blank. If I add old billing to the blank billing I get #error. ...
February 27th, 2007 07:07 AM
by Duane Hookom Go to last post
2 66
Post New Thread


Display Options
Showing threads 41 to 60 of 28846
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.