Hi,
I have created a report which uses references from several queries, taking only a specific record depending on which Week number they type in. In one of these queries is a running total using the code:
Where 'Week number' is determined by the result of another query asking for input on the week number.
So
When I openb the report in report view it asks for a week number, and If I type in "8" it will return all the records from week 8, including a running total up to week 8.
The problem is, now my boss has asked me to do a total of ALL records for the week that gets inputted, and when I added a textbox at the bottom of the report with an expression of
etc, it returns ############################################## in the textbox in report view. I know it's not an issue of textbox width because I can widen it as far as possible and it still just says ##########.
I'm guessing there is a problem with creating a sum of running totals, but I'm not sure where the problem is or how to fix it.
Any help would be much appreciated! :banghead:
EDIT:
I've just discovered that when I show it in report view, it isn't actually adding the numbers together into the textbox, but writing both num,bers side by side. For example:
If [Text311] was $45 and [Text312] was $99, the textbox prints "$45$99"
I have created a report which uses references from several queries, taking only a specific record depending on which Week number they type in. In one of these queries is a running total using the code:
Code:
RunTot8: DSum("[Rotorua_TotalSales]","[AllData]","[Week Number] <=" & [Week Number])
So
When I openb the report in report view it asks for a week number, and If I type in "8" it will return all the records from week 8, including a running total up to week 8.
The problem is, now my boss has asked me to do a total of ALL records for the week that gets inputted, and when I added a textbox at the bottom of the report with an expression of
Code:
[Text311]+[Text312]+[Text313]
I'm guessing there is a problem with creating a sum of running totals, but I'm not sure where the problem is or how to fix it.
Any help would be much appreciated! :banghead:
EDIT:
I've just discovered that when I show it in report view, it isn't actually adding the numbers together into the textbox, but writing both num,bers side by side. For example:
If [Text311] was $45 and [Text312] was $99, the textbox prints "$45$99"