Reports
in [Access]
|
combine 2 names? I am going to be printing mailing labels for my church and I need to know if it is possible if I have a table with separate names for both spouses (and it includes their same address, phone #, etc.) to somehow join the married ones together for a mailing label report? If that is possible, how do I deal with marrie... 11 Jul 2006 22:32
Pie Chart i am trying to enter a pie chart on to a report based on a query. The chart wizard is not allowing me to enter the chart. I can get as far as choosing the type of chart then it will not allow me to lay out the information for the chart. The error message i'm getting is "Object or class does not support the s... 6 Jul 2006 16:00
Cannot create a Report I'm still farily new to Access and need help with this simple problem. I have been unable to create any reports. When I try to create a report with a report wizard, I get the message "The wizard is unable to create your report." When I click on Design to create a report in design view, nothing happens. Why ... 29 Jun 2006 12:39
Controlling field width? I have two fields in a report that are printed next to each other. Field 1 prints various text based on certain conditions and varies in length, ie 1 - 4 words. Field 2 prints next to it. If I give Field 1 enough space to print its max length it leaves a lot of blank space between Field 1 and 2 when Field 1 ... 14 Jun 2006 12:14
TWIPS and Pixels Hello All! I've been having trouble with this for some time, and I keep coming up with new information, but as yet, no solution. I am printing barcodes on Access Reports using my own code. The function takes a Container (the report) and a LabelZone (a report rectangle object) to place the Code (passed as a st... 14 Jun 2006 23:11
How do I show net profit on income statement Using Access Reports and views. I already managed to show: 1. the income amount for each income account 2. the total income using a group footer sum. 3. the expense amount for each expense account. 4. the total expense using a group footer sum. I could do those because my tables and views merged into a view in w... 13 Jun 2006 00:05
Suppress Line Printing I would like to suppress printing a line if a calculated value on that line = 0 thanks, ... 10 Jun 2006 11:29
How do I get the time to show in my report? I am running Access 2000-2003 and designed a databass for our call-center. When adding a new record in the forms moduel the time is automaticaly filled in. When I run my report at the end of each day, the time when the call came in does show up on the report for each call-in request. How do i get the time to ... 24 May 2006 13:53
SUM I would like to have a field on the bottom of the page that will give the sum of a certain filed. For example I have a field "price" on the bottom of each page I would like to have the total for "price" from the whole page (not report). ... 17 May 2006 19:11
Access 97 Legal size I have several reports that are designed for legal size printing. I am using Access 97. It seems when printing they revert to standard size. Therefore I have to go into the page set up every time a user prints the report and change it to landscape. Is there any VB code I can use to automate this process? -- ... 9 May 2006 09:34 |