| Thread | Last Post | Replies |
|
| Pie Chart | 18 Jan 2006 00:07 GMT | 1 |
How do you add a pie chart to an Access report? Thanks Don
|
| Export Report To Excel | 17 Jan 2006 23:03 GMT | 3 |
Access has built-in function to export report into Excel. But for report which has grouping, the result is messed. Is there any better solution for exporting report to Excel ? Thanks.
|
| Hiding Non-Value SubReport | 17 Jan 2006 22:40 GMT | 4 |
I have a report which contains a subreport. The report is grouped by Student ID, and I have the subreport in the Student ID header section. Sometimes, there are no activities for that student. In that situation, the subreport section is blank but the header of the subreport is ...
|
| How can you sort groups in an Access report? | 17 Jan 2006 22:00 GMT | 10 |
I have a report that groups teams together. Each person within that team has a score which is subtotaled for a group total. How can I sort the teams by this subtotal? There has to be a way!!
|
| How can I format color in my query | 17 Jan 2006 20:26 GMT | 3 |
When i run my query i've realised i got negative numbers.So i'd would like to change the color for the negative numbers numbers to red.And the positive ones should remain black.how can I do this
|
| summing unique values in 2 seperate footers | 17 Jan 2006 20:06 GMT | 3 |
i have a report with 2 sorts and 2 footers. i need to count unique values over the whole group. i can use a text box control to =1 and sum over group option, however, i am only interested in the very last entry that method produces.
|
| Subreport - Conditional Distance from Top | 17 Jan 2006 19:41 GMT | 3 |
I'd like to set the distance from Top of a subreport at Runtime, depending on the contents of a Detail field I've tried the code below plus variations , but the effect is to blank out the subreport entirely on the parent report for every detail record.
|
| Some subreports hidden when no data, others visible!? | 17 Jan 2006 19:17 GMT | 2 |
I have a report with 5 subreports. I believed I had built them from the same template but one of the subreports show up in the report even if it has no data. The others don´t. Is there a setting for this or what else have I missed.
|
| "Contd from previous page" when groupheader or pageheadersection.. | 17 Jan 2006 18:29 GMT | 25 |
I am asking for more help because I really need it. I have a report with a subreport in it. The page format is as follows: Product ID [Subreport showing each item per product] I would like "Contd from previous page" to show up at the top of each page
|
| Count dates | 17 Jan 2006 17:43 GMT | 10 |
I have a report that lists how many times a day a driver delivers another load, I would like to count the number of days in the report it could be three days etc... but the date is listed multiple times due to the number of loads. Can I do this on my report with a distinct.date ...
|
| Problem linking SubReport - object defined error | 17 Jan 2006 17:24 GMT | 1 |
I'm having trouble linking a subreport. I've done this many times in the past with forms and reports and I've narrowed the problem down to the crosstab query. I created a crosstab query and then joined it to other tables in another query. I'm using this query in the subreport. ...
|
| Filtered form results to a report? | 17 Jan 2006 16:50 GMT | 9 |
I made a report for a #10 envelope but I dont know how to make the filter I used for my address list show in the report? So I filtered my form on one persons last name. I want to print my #10 envelope report with his name. But when I go to that report it shows all my records. I
|
| Printing Chart within a Report | 17 Jan 2006 16:18 GMT | 1 |
I have created a line chart that pulls date from a table. Field 1 is my x-axis, Fields 2 and 3 are my data points, Field 4 is the criteria for which data is pulled and Field 5 links the chart to the report. I have the report sorted by Field 5 and the chart within this header; it ...
|
| Counting records only under certain contitions | 17 Jan 2006 16:17 GMT | 6 |
I have a data base of qoutes issued during the year. I am trying to generate a report giving total number of quotes as well as the total number of quotes that generated an order. Within the data base is a field "Status/Reason" that contains either the string "1 (ORDERED)" or is ...
|
| Emailing From Access | 17 Jan 2006 16:12 GMT | 4 |
I have this code that sends an E-Mail from Access it works great. I just need a few adjustments to complete it. First...I get a messagedox to select a profile...is there any way to supress this?
|