| Thread | Last Post | Replies |
|
| Sorting according to field chosen after report previewed | 07 Sep 2005 21:47 GMT | 2 |
I have a report based on a parameter query. In the detail section, there are several fields such as Field1, Field2, Field3 etc. The report is already sorted according to one field, say Field1. How can I introduce a feature into my report by which it can be sorted by another ...
|
| Watermark | 07 Sep 2005 18:14 GMT | 4 |
Can someone advise me how to create a custom-made watermark on the diagonal of each page of a report. Thanks, Ray
|
| SUM using two feilds | 07 Sep 2005 18:08 GMT | 1 |
I would like the report to give me a Sum in a text box but only if it meets the criteria of two fields. I know how to do it for one. I have been using the following for just one field. =Abs(Sum(Left([ED_Code],1)="L"))
|
| Text Color | 07 Sep 2005 17:15 GMT | 1 |
I would like the text or text box to be red if the value is 0 or less and be Green if it is 1 or greater. Thanks Keith
|
| Print labels on left side of report | 07 Sep 2005 16:40 GMT | 6 |
I used the instructions from article Q210044 to show my monthly data in columns, which worked great. My question is that since I had to set the width property of the report to 2", my report and page headers are also 2". I need to have a longer report title. Is there any way ...
|
| Multiselect listbox for parameter query? | 07 Sep 2005 16:19 GMT | 1 |
I have a report based on a query, with two parameters from the query chosen in a form's comboboxes. I want to convert the form to multi-selection listboxes and still have the rest work. This is the current procedure: 1. When I open the report, the following procedure runs to ...
|
| Report multiplication/sum query | 07 Sep 2005 16:17 GMT | 1 |
I have 2 fields...'quantity' and 'usage' I have grouped the report by site The detail of each site has both fields. I can easily list both fields and insert another field, 'total', which is
|
| Totals of several calculated fields / controls | 07 Sep 2005 16:05 GMT | 3 |
I've looked at the suggestions for totals in Access Reports (using totals as the search phrase) and didn't see anything that will really help. I have a series of fields / controls that are calculated text boxes. The basic calculation in each control is [County Rate] * [Amount ...
|
| Sub reports | 07 Sep 2005 15:28 GMT | 1 |
I have inherited some else Access report. This report has some major performance problems. The report has three sub reports. Could that be the source of my problems?
|
| My computer can't open or create reports in wizard anymore | 07 Sep 2005 13:44 GMT | 1 |
my database was working correctly until It gave me an error that say" This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file?" and I chose open.After opening this database, I was unable to create reports using wizard ...
|
| Graph not representative of data | 07 Sep 2005 13:43 GMT | 1 |
I'm trying to update one of our custom reports that has been written in access. The report uses a mixture of live data and batch generated data to generate the final results. the report has three main graphs, and they all have the same problem - they
|
| My earlier post regarding Empty Field on Close | 07 Sep 2005 12:38 GMT | 1 |
I'm afraid I wasn't very clear on my previous post, my bad. What I want to do is; if the report has no records, I want to something and if the report has record(s) I want to do something else OnClose.
|
| Probably an eaasy one! Please Help??! | 07 Sep 2005 09:44 GMT | 4 |
I would like to calculate a running sum of a field where the values in that field are Null. I have the basic expressions for a sum to be calculated when the field is not Null i.e.: =IIf([WI Progress] = "Completed",1,0)
|
| Running Sum for Specific Values | 07 Sep 2005 06:08 GMT | 3 |
Ok, I've got a table which has an the monthly totals for certain species of birds. On each value, there is Bird Species, Total Blood Samples, Total Recaptures, Total SLE Positive, Total WEE Positive, Total WNV Positive, and Total Repeat
|
| Images in reports | 07 Sep 2005 05:45 GMT | 2 |
In the article "How to Display Images in a Form Without Storing the Images in a Table" it is explained that you put the filename in a text box, add an image control to the form, and then put a tiny bit of code in the OnCurrent & After Update events:
|