Stewart, thanks for the response.
I'm sorry, my description of the problem was a bit imprecise.
What I'm really trying to do is get the data in my temp table to appear in the acDetail section of my report WITHOUT pushing down the rows of data that are shown in acDetail. This needs to happen as the data in acDetail is grouped by a field, and the data in the temp table is related to each section of acDetail that's grouped....
talktozee2
Last Activity: Dec 12 '08, 10:42 PM
Joined: Feb 25 '08
Location:
-
Ok, I've stored the data in a temporary table, but now I need to display the data in the "acDetail" section WITHOUT it repeating X times for each row of data. Anyone?Leave a comment:
-
Show a Control with array data on a Report after query is complete
Hi, everyone.
My problem is a bit too complex to explain in writing, let alone in the title of my post, but I'll give it a shot.
I have a report that has a basic set of columns and rows, but complex calculations are run between cells of each row, and between cells of different rows. Based on these calculations some rows are hidden and some are not.
Now, I need to temporarily store paired data ("date"... -
Delerna,
Once again you are quite right. My 3rd statement did NOT work, but neither does my 2nd statement. Any suggestions? Where am I going wrong?Leave a comment:
-
I think, because of the relationships of fields/controls, this works:
Code:=IIf(([transfer_to]=0 Or [transfer_to]=[current_investorID]) And [current_typeID]<6,[amount],0)
Leave a comment:
-
Using multiple OR statements in IIF, or nesting
Hey, all.
I've tried both of the following methods, but neither is working. Suggestions?
Basically if any of the conditions are true, insert [amount], if not insert 0.Code:=IIf([transfer_to]=0,[amount],IIf([transfer_to]=[current_investorID],[amount],IIf([current_typeID]<6,[amount],0))) =IIf([transfer_to]=0 Or ([transfer_to]=[current_investorID]) Or [current_typeID]<6,[amount],0)
... -
Wow, a major breakthrough. I was writing all of this code in a separate Module in Access; instead, I moved all of the code into the actual report and voila, everything started to work. I was under the impression that it had to be in a Module for more global accessibility but putting the code for hiding rows (using the Visible property) and for running the calculations was MUCH easier once it was in the actual report's VBA code section.
...Leave a comment:
-
- Yes, I'm calling the report from a from using a button
- I like the idea of storing the results in a table and then performing calculations to get the 12 rows, but this all seems a bit excessive to remove whitespace from a report
Regarding your second solution:
- The table does have an autonumber field, so that's not a problem
- I do run a calculation on each "month" (actually, each transaction), but...Leave a comment:
-
Thanks, I appreciate it. The math may be a bit off, but that's because it's dummy data. But it should be close.Leave a comment:
-
...Code:date typeID amount investorID 6/1/2006 2 $600 11 6/1/2006 2 $100 5 6/1/2006 2 $440 10 6/1/2006 2 $160 7 6/1/2006 2 $2,000 3 6/1/2006 2 $440 2 6/1/2006 2 $260 1 6/2/2006 4 $39 0 6/3/2006 2 $100 13 6/3/2006 2 $478 16 6/3/2006 2 $428 12 7/31/2006 4 $53 0 8/31/2006 4 $57 0 9/30/2006 4 $54 0 10/31/2006 4 $54 0 11/30/2006 4 $57
Leave a comment:
-
Almost like what this person is trying to do:
** Edit ** Link to competing forum removed as per site rules.Leave a comment:
-
Because each new row's data is based upon running totals and percentages that are calculated as each previous row of data is processed. Do you think this type of math is possible in a query? If so, I'm all ears.Leave a comment:
-
Right. And I can "hide" the rows on the report (i.e. they are "white") but they still take up space. I've tried the Move method, the Visible, Left, Top, Width and Height properties but nothing is working. It's been driving me nuts...Leave a comment:
-
talktozee2 started a topic Hide rows in report & eliminate whitespace, but still reference the valuesin AccessHide rows in report & eliminate whitespace, but still reference the values
I'm basically trying to replicate Excel in an Access report.
I have 30+ rows of data from my query, and I need all 30+ rows to perform some calculations in VBA to distill the 30+ rows down to 12.
I'm able to get the data and perform the calculation AND hide the unwanted rows by setting their Height = 0, but they still take up whitespace.
I've tried to set the Visible property on each row to False, but...
No activity results to display
Leave a comment: