| Thread | Last Post | Replies |
|
| Help setting up reports | 03 Nov 2006 05:05 GMT | 1 |
I have a data sheet template for electric motors that has about 20 fields. All of the information regarding the motor is stored in a single table. I need to setup a form/report so I can select multiple line items in the table and print the datasheets for those items. ie I want ...
|
| Two Column Report Problem | 03 Nov 2006 03:18 GMT | 6 |
The report I am trying to create is needed to display as follows: Name Address City State Zip
|
| Sorting Military time for shift 23:00 to 07:00 | 03 Nov 2006 02:46 GMT | 4 |
I am putting together a report which list activity from 23:00 hours to 07:00 hours. My problem is sorting it by time. I would like to to be 23:00 hours first then start 00:00 second. In my report I can only go ascending which puts all times 23:00 last
|
| Chart legend problem ("SumOf") | 03 Nov 2006 02:29 GMT | 3 |
Using the chart wizard, I have created a line chart based on a linked excel table. The x-axis is Months, and the y-axis is $. The table works great, except the legend shows "SumOfName1", "SumOfName2" etc. where Name1 and Name2 represent the names of each set of data. How can I
|
| Sub Report and Report totals question. | 03 Nov 2006 01:09 GMT | 3 |
I have a report that displays a base salary (which is a calculated field in my query), then my subreport displays an employee's various supplemental $ (sometimes 0 line items up to 7 supplements). How do I get my report to display a total salary of all this money? This would ...
|
| Report printing lots of identical pages. | 03 Nov 2006 00:06 GMT | 2 |
I built a report that is an analysis of the values in a table. I am counting records based on one criteria and totaling based on another. I have got the report working with the exception that I get a page printed for each record. Seeing as the report is essentially a summary, I ...
|
| Using Info from a subReport | 02 Nov 2006 19:13 GMT | 1 |
I want to use a customer total in a sub Report and add that to the total of the same customer's results on the main Report. Is this possible? How can I do this?
|
| Reports in Access 2002 | 02 Nov 2006 18:08 GMT | 1 |
Is there a way to set up a report with multiple columns?? We currently have an overtime sheet that reflects employees overtime for a 14 day pay period. I am trying to come up with something similar without it being a very lenghtly report and something easy our managers can ...
|
| Average in report based on crosstab query | 02 Nov 2006 15:48 GMT | 4 |
I created a report based on a crosstab query that lists all the charges per terapist (rowheads) ordered by month (columnheads) for one year. At the end for every therapists line, I would like to have a field calculating an average for the year, even when the year is not yet over. ...
|
| Using (month(date)+2) errors out because of end of year | 02 Nov 2006 13:27 GMT | 3 |
I have a report where I use this syntax: (month(date)+2) to show some totals projected two months forward, but since it turned November the adding of 2 months to the current month errors out the
|
| Check box value in report | 02 Nov 2006 11:34 GMT | 1 |
I have a form that contains many check boxes. I created a report from this form. In the report, all check boxes appears with value -1 ( when they are checked in the form) or 0 (when unchecked). In the report, instead of values -1 or 0, I would like to see a check (√)
|
| Custom Sorting | 02 Nov 2006 10:32 GMT | 1 |
Using A2k Trying to determine how I can have a report be sorted based on user input. My thoughts were to create a form to establish the user's preference for sorting, then pass that value through the query. However, I cannot do IIF
|
| If CheckBox is checked, display field name | 02 Nov 2006 04:16 GMT | 5 |
I have a database that tracks medical facilities. Each facility has at least one Specialty classification (ex. surgery, pediatrics, cardiology, etc), and many of them have several Specialty classifications. The facility name is the Primary key for the table that stores the info ...
|
| vary report label caption using form & table info | 02 Nov 2006 03:10 GMT | 1 |
I'm trying to set up a report template as a form letter that can be used in multiple situations where the bulk of the letter is always going to be the same/use same fields but the intro and 2nd paragraph will change depending on the letter choice. In addition, if the letter ...
|
| Report text field: You can't assign a value to this object | 01 Nov 2006 23:10 GMT | 4 |
I have a report that has a query as its record source. I also have a Report Menu form, where the user enters dates (in text boxes), selects the report to be displayed, and the report is opened. The query selects records based on these dates.
|