Thank You so much guys.
I went back and really had a go at figuring out how the whole listbox thing works. Then i came back to the code you provided 'dpatel1682' and it really did the trick.
Thanks again
govnah
Last Activity: Jun 1 '11, 09:15 AM
Joined: Jun 1 '10
Location:
-
Thank you NeoPa,
Yes please, i would like it to give the sub-report's total result which evaluates to zero when there is no data.
Quick question, when the sub-report has no data, is there literally a hole left in the main report? or the hole will be filled with the other sub-report?
Example:
On the main report, subRpt1 has no data therefore it doesn't run. Will subRpt2 move up and occupy the space that...Leave a comment:
-
Thank You Guys for taking time out to help.
So sorry, for the lack of details.
I thought of a different workaround to the problem. I decided to add a default record to the sub-report so that there is always data in the sub-report to show. Also i think the problem was caused because the results from the sub-reports were not calculated with Nz(). I didn't know Nz(Sum(Price),0 ) is a way better solution than Sum(Price). ...Leave a comment:
-
dpatel1682,
Thank you for taking the time out to post the sample.
I noticed you don't have a loop in your code, which will check every column (record) in the listbox. That's what i'm struggling with.
how come you're your using this? "Me.List5.Colum n(1)"
I think thats...Code:"having Main_Account_Type = " & "'" & Me.List5.Column(1) & "'"
Leave a comment:
-
Hi there, I am trying to do something similar to what you just achieved. I was hoping you could post the code you used to solve the problem.
Many ThanksLeave a comment:
-
@MikeTheBike
Thank you so much for taking time out to help me out :)
YOUR CODE SOLVES THE PROBLEM. Thank you againLeave a comment:
-
Thank you soo much for replying. I tried your suggestion but now its giving me "0" as a result instead of "1".
This is me trying to make my problem more clear.
----------------
reservation_tb (current records)
reserveID | roomID | from | to | status
1 | 2 | 26/07/2010 | 30/07/2010 | Reserved
2 | 4 | 26/07/2010 | 28/07/2010...Leave a comment:
-
help with how to Dcount two fields in one table
Hi everybody,
I am struggling with finding the write way to achieve a certain task. I hope someone can help me.
Problem:
I have a table
[reservation_tb]
-reserveID
-roomID
-from :[date datatype]
-to :[date datatype]
-status
On Reservation form. I have a button that will check if the reservation_tb table has a room reserved within the... -
govnah started a topic Report totals says, "#Error" when i print. But looks perfectly fine in Printviewin AccessReport totals says, "#Error" when i print. But looks perfectly fine in Printview
Hi mighty fine people,
I have a report with two sub-reports attached. The Main report calculates the totals of the two sub-reports.
The problem i am having is that when i open the report, it looks perfectly fine; the totals are calculated perfectly. But when i actually print the report, the total field shows #Error on the printed paper.
I was reading around and it looks like, and i've verified that the...
No activity results to display
Leave a comment: