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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
criteria issue
You should add a text box at the right group footer, not page footer. Again,
you can let the Report Wizard do it for you, with a new report. Name the text box by something ELSE than an existing field name, and, in its control source, type: =SUM(OrderQty) The irregular line spacing may be due that you have an empty record, or that you print some group footer, or group header, with nothing in it, and what you see is just the paper space it consumes, even if there is no control in its section. Vanderghast, Access MVP "bigwillno2 via AccessMonster.com" u32748@uwe wrote in message news:71a1759e08ebe@uwe... one last thing....how can add all this numbers.......i know it's a =sum() at the report footer, but what expression, this =sum(OrderQty) has no name and when i give it a name, it gives me and error when i try to add it..in the report footer.....thanks again. bigwillno2 wrote: Hey Michel, thanks for your help, you have been soooo patient with me and love that.... thanks again.... one more question....why the result come with different spacing between them. e.g... result1 result2 result3 result4 thanks again for your help...you the best The ordering defined in the query WON'T be considered in the report unless you do it specifically (same properties sheet, "SORTING and grouping"). So, [quoted text clipped - 10 lines] you think.....? thanks again. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200705/1 |
#22
|
|||
|
|||
criteria issue
I got it, you was a great help, Michel, i which everyone was like you...with
patience....man......i got it working thanks again...... Michel Walsh wrote: You should add a text box at the right group footer, not page footer. Again, you can let the Report Wizard do it for you, with a new report. Name the text box by something ELSE than an existing field name, and, in its control source, type: =SUM(OrderQty) The irregular line spacing may be due that you have an empty record, or that you print some group footer, or group header, with nothing in it, and what you see is just the paper space it consumes, even if there is no control in its section. Vanderghast, Access MVP one last thing....how can add all this numbers.......i know it's a =sum() at [quoted text clipped - 28 lines] you think.....? thanks again. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200705/1 |
#23
|
|||
|
|||
criteria issue
Hey Michel,
sorry to bother you again, but i got a little issue with that footer section.. .. it's not coming up in a export that i have to do to an excel sheet......do you happen to know why it's doing that.....it's exporting the other stuff on the report but that section...that new group footer that you helped me with... i hope you could help with this. thanks... bigwillno2 wrote: I got it, you was a great help, Michel, i which everyone was like you...with patience....man......i got it working thanks again...... You should add a text box at the right group footer, not page footer. Again, you can let the Report Wizard do it for you, with a new report. Name the [quoted text clipped - 15 lines] you think.....? thanks again. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200705/1 |
#24
|
|||
|
|||
criteria issue
Well, that is because a report is not really meant to be 'exported' (unless
you mean something like exported into a pdf 'file'). You have to go back to a query, and use DoCmd.TransferXXX (or equivalent). The query can then have the criteria inside it, in its WHERE clause, and can be a Group By query (also called a Total query) so you can SUM or use any relevant aggregate. Vanderghast, Access MVP "bigwillno2 via AccessMonster.com" u32748@uwe wrote in message news:71a3ca725fc8c@uwe... Hey Michel, sorry to bother you again, but i got a little issue with that footer section.. . it's not coming up in a export that i have to do to an excel sheet......do you happen to know why it's doing that.....it's exporting the other stuff on the report but that section...that new group footer that you helped me with... i hope you could help with this. thanks... bigwillno2 wrote: I got it, you was a great help, Michel, i which everyone was like you...with patience....man......i got it working thanks again...... You should add a text box at the right group footer, not page footer. Again, you can let the Report Wizard do it for you, with a new report. Name the [quoted text clipped - 15 lines] you think.....? thanks again. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200705/1 |
#25
|
|||
|
|||
criteria issue
Hey Michel,
it works fine now, thanks a lot.........i had to go back to the grouping thing and have the header show up, head does export it and does everything else the footer does. thanks.....again Michel Walsh wrote: Well, that is because a report is not really meant to be 'exported' (unless you mean something like exported into a pdf 'file'). You have to go back to a query, and use DoCmd.TransferXXX (or equivalent). The query can then have the criteria inside it, in its WHERE clause, and can be a Group By query (also called a Total query) so you can SUM or use any relevant aggregate. Vanderghast, Access MVP Hey Michel, [quoted text clipped - 18 lines] you think.....? thanks again. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|