Reports
in [Access]
|
Access 2003 - Chart Question Hi I am creating charts in reports and was wondering can you create a chart in a report that uses the data from text boxes as the source data? eg I have text boxes that use a IIF statement to count the total amount of: Groups of 1 Groups of 2 Groups of 3 Groups of 4 or more - that have visited a rec centre... 10 Apr 2006 23:04
ASCII code for Tab Issue When I try and put the ASCII code for tab chr(9) (?) in a text box it gives me a symbol like [] instead of a tab. I've seen several post about carriage returns and line feeds where you need to use two items back to back. Is this a similar issue? Any help is greatly appreciated. Brent ... 5 Apr 2006 19:07
Page setup for Report Exported to Excel Is there a way to have a report export to excel and automatically be setup for print on 1 page wide by 1 page tall in Landscape mode? When I use the DoCmd.OutputTo command it seems to set everything up portrait and ignores the margins I have set on the report page. Any help is appreciated....Thanks Brent ... 3 Apr 2006 17:34
I figured out the Weight Calculations Issue I named each of my fields as follows: Detail: NetProfit Division: NetProfit DivTot Region: NetProfit RegTot Report Tot: NetProfit GrandTotal I also pulled the fields from my query that were in the calculations but not in the reports and set them to invisable. I was able to take advantage of Acces... 26 Mar 2006 18:16
conditional formatting and expressions I created a report and I am trying to use conditional formatting on an expression. My expression show the variance between two numbers and I would like the negative numbers to show in red and in brackets. I have read all the strings, but I cannot find anything similiar. Thanks for your help. ... 21 Mar 2006 18:23
Subreport Total on Main - Doesn't see subreport I am working in Access 2003 SP2. I would like to total the main and subreport. I have already created one report that works fine. I have followed the examples in the previous newsgroup questions, but my problem is: If I create a textbox and enter one of the subreports into the formula, it shows up just fine... 16 Mar 2006 22:06
Create a calendar report in access I want to create a report of upcoming bills in access (Access 97) that would cover a period of two weeks. I hope it to appear as: Sun Mon Tues Wed Thurs Fri Sat Elec water cable Sun Mon Tues W... 13 Mar 2006 22:15
Negative numbers and percentages I have a form that populates a report with a number of respondents and a percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said 'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that are coming out as negatives. The control sources are: For the 3 it's: SumOfQ1good For the ... 15 Mar 2006 10:41
How do I print a page of the same address label on Avery L7161 lab I'm able to print individual labels and sheets of different address labels from my database, but cannot figure out how to print a whole sheet of the same address label. Can anyone advise me? ... 28 Feb 2006 11:54
How can I set up page break in MS Access reports after sub-summary For example after sub-sumary for one planner. ... 27 Feb 2006 16:05 |