| Thread | Last Post | Replies |
|
| Printing Blank Records to Complete a Report | 30 Nov 2007 21:37 GMT | 18 |
I need to create a report that completes a page with blank records. I have the report set up so that detail fields print with borders. There need to be (12) lines of detail records printed regardless of data (i.e., 2 actual records - print 10 blank, etc.). I used field borders so ...
|
| Line across columns in report | 30 Nov 2007 21:09 GMT | 1 |
I have a 3 column report. I want a line to go across the bottom of each address. When I insert a line it underlines columns 1, 2, and 3 separately. I want it to be a line across the entire page with no breaks. How would I go about doing this? Thanks in advance.
|
| sub report text field not visible in main report | 30 Nov 2007 20:58 GMT | 8 |
So here's the situation. I have a report that contains a sub-report in a group header. In the footer section of the sub-report, there are 5 text boxes. The values in these text boxes are generated by a series of if statements when the report loads. If a certain field
|
| subreport totals | 30 Nov 2007 20:24 GMT | 1 |
i have two subreprts in one report. the first subreport is called subreport managed account performance and the total field is called total open amount. the second subreport is called subreport partnership report and the total field in this subreport is called total addition. i ...
|
| Subreport problem with COUNT and GROUP BY | 30 Nov 2007 19:16 GMT | 3 |
Trying to create a report with a subreport. The subreport needs to run a query that returns a list of Home Grades with a Count per Grade. This in turn needs to be done for each Neighborhood in the main report. The report would look something like this:
|
| How to replicate Excels' numeric "Accounting" format in Access Rep | 30 Nov 2007 18:14 GMT | 13 |
How to replicate Excels' numeric "Accounting" format in Access Report client want's Access report to output values in format identical to Excel's numeric "Accounting" format if I try to difine it as such it converts the 'Format' definition to >>
|
| Field sorting problem | 30 Nov 2007 17:56 GMT | 2 |
I have a query that returns data sorted on 2 fields. Name and then RequestDate. When I put this into a report the Name field is sorted ascending but the RequestDate field is sorted randomly.
|
| print query prompts in report header when no data to report | 30 Nov 2007 17:55 GMT | 1 |
a report which uses a Query with prompts(expr1: xyz) and other criteria selects no records. The report header prints, but (expr1) which is a field in the header is blank. I want the prompts to print in the header even when no data is found.
|
| Using code to display data in Report | 30 Nov 2007 17:32 GMT | 4 |
I want to generate report using query. My query is simple "Select GMTDateTime, ConvertToLocal(GMTDateTime) as LocalDateTime from tbDateTime"
|
| Start label in middle of page | 30 Nov 2007 17:00 GMT | 1 |
Using labels for a laser printer I would like to instruct the report to start printing on a spesific row.. Reason, sometime you only print one or two rows. The next time that you print labels you must be able to instruct it on which row to start printing.
|
| report - remove null fields | 30 Nov 2007 14:11 GMT | 2 |
Access 2007, I am making a report with several fields. If a field is null (contains no information), I want that field removed so that only fields containing information are displayed/printed.
|
| Get rid of Currency Decimal places | 30 Nov 2007 13:37 GMT | 2 |
I have researched Format and cannot find the answer to what a question that probably has a simple solution. I have a report that shows a contract value. In the table where the data is stored it is a currency data type set with 0 decimals. On the report is
|
| using add query with subform fields | 30 Nov 2007 06:03 GMT | 1 |
I am trying to run an add query and add data from a running subform into a table. everything is working fine except for the fact that only the first row of data from the subform is being added to the table. is there anyway that I could arrange to have all the rows in the subform
|
| list of search criteria | 30 Nov 2007 02:39 GMT | 9 |
I have a report that I print to pdf. I have 10 cities that I want to use individually as the criteria in the query field[city]. How can I make the report use city1, then city2, etc as the criteria for the report?
|
| Add signature to report | 30 Nov 2007 02:36 GMT | 3 |
I'm trying to add a signature to a report. A form has a subform and a command button. The user picks from the subform clicks this command button and the report is displayed. (This works fine) stDocName = "rptThankYou"
|