| Thread | Last Post | Replies |
|
| Simple Report Totals | 29 Mar 2007 01:23 GMT | 1 |
I have a report based on a query of the Amount Paid by indivuals and the dates of payment. For simplicity: Name----Date of Payment - - - -Amount Paid I run the report preview and get:
|
| change view of a report | 29 Mar 2007 00:36 GMT | 2 |
I have a table with the month and year vertically but I need the month and year to go horizontally. How do I do this so my end result can be printed on a report? Would it be through a pivot table query? I need to show products on the left and months on top so we can get a ...
|
| Report-Multiple Columns | 29 Mar 2007 00:28 GMT | 3 |
In a report with three columns is it possible to print the labels for each field only for one column. Namely the column on the left side of the printed report. I would like to just print the field data in the second and third column.
|
| Sums from Multiple Queries on one Report | 28 Mar 2007 21:07 GMT | 1 |
I am trying to pull the data from multiple queries into one report. Specifically I want to be able to sum the field "Purchase Price" from each query. However, I keep getting an error message when I run the report. What is wrong with the below data?
|
| Need Subform Record Count in Report | 28 Mar 2007 21:04 GMT | 4 |
I have a form and figured out how to determine the number of associated records that appear in a subform for each ID using the RecordCount object property and display that number on the main form. I'm now trying to create a report that shows that number as well. I tried to just ...
|
| sorting | 28 Mar 2007 20:00 GMT | 6 |
I want a report to sort in ascending order by the number in a field. The numbers are 1A, 1B, 2-9, 10, 11A, 11B, and 12-18. It is sorting in this order - 10, 11A, 11B, 12, 13, 14, 15, 16, 17, 18, 1A, 1,B, 2-9.
|
| Conditional Count | 28 Mar 2007 19:52 GMT | 2 |
I have a database of employee complaints and need to add a field to the report that will count all complaints still under investigation that are older than 60 days. Our "Action Taken" field is where we indicate "In Process". I set up the following expression, but it did not ...
|
| Freezing Lines | 28 Mar 2007 19:49 GMT | 3 |
I'm trying to design a report that has a list of items on the left margin with horizontal lines between each item. I want the lines to be specifically 4 dots apart as viewed in Design View. That works with the default 8 point font, but should I change to 9 point for easier reading ...
|
| Report Question | 28 Mar 2007 19:36 GMT | 6 |
Can anyone explain to me if it is possible to take a text field in a report to make it simulate columns without changing the page setup options. Any help is greatly appreciated. Thanks! Kbrad28
|
| Want to find average and color code | 28 Mar 2007 19:06 GMT | 1 |
I have a report that sort overtime hours from low to high and would like to inclued the average in the header on the report. when I add the average to header or footer for that mater the sort on the overtime hours become unsorted. Is there a way fix this and also have the ...
|
| Getting a SUM from 3 different Text boxes | 28 Mar 2007 18:46 GMT | 8 |
Hi all, I have 3 different but similar text boxes. They are txtcontroller, txtcontroller2, and txtcontroller3 Basically, in my table I need to track different people involved with a certain task, this is why I have the 3 of them
|
| Printing labels | 28 Mar 2007 18:19 GMT | 1 |
I have a program that prints labels. We just changed the size of label. When we printed using the old size the printer would ask for 'manual feed'. Since we changed the label size, it no longer does this. Does anyone know what triggers the manual feed as this is what we want and ...
|
| Sorting Problem | 28 Mar 2007 16:50 GMT | 8 |
I deleted a previous question on this, but I now can't view the thread. Please accept my appology. I need to start again. Field: DBxInst: ([DBNum]*1000)+[Inst Num] Field: TheSortOrder:
|
| Exporting to excel is truncating my data | 28 Mar 2007 16:20 GMT | 2 |
When I export a report that I have some of my fields are being truncated. The fields being truncated are memo fields, but it is truncating to less than 200 characters. Can anything be done to prevent this from happening? Is there a limit on what can be exported to Excel? Some ...
|
| Columns in subreport | 28 Mar 2007 16:10 GMT | 1 |
I have a subreport that I'd like displayed in three columns. I've set the columns the way I'd like them in "page setup". The subreport is 1" high and 5.5" wide. Presently I only get one column and whatever is below that column doesn't display.
|