| Thread | Last Post | Replies |
|
| is there a limit to the data that can go on reports from memo fie. | 24 Nov 2004 16:45 GMT | 1 |
I am trying to create a report that includes two memo fields. The first memo field appears in its entirety, but the second memo field is truncated? Is there any way around this?
|
| All data does not show in memo field in report | 24 Nov 2004 14:46 GMT | 1 |
How do I get all of the data to show up in a memo field when I pull up the report? I have made the box big enough but the data just stops.
|
| Count unique records | 24 Nov 2004 13:48 GMT | 3 |
Does anybody know how to count the number of unique records by another field in a report? Sample Data: BLD 1 UNIT 101
|
| Can a report skip a blank field while printing? | 24 Nov 2004 05:27 GMT | 2 |
I am generating a report in Access. I would like the report to skip a blank field and go to the next field without printing a blank line. How do I do this?
|
| Length of 'detail' are in report | 24 Nov 2004 03:52 GMT | 1 |
I created a report with 2 grouping levels, as follows: - Borrower - name, address, etc. - prints at the top of the first page for each borrower report - Loan # - Loan #, loan amount, loan date, etc. - prints at the top of
|
| chapter name on every page | 24 Nov 2004 02:56 GMT | 1 |
I have a report with a Page Header and Chapter Name header. Is there a way to force the Chapter Name header to show on every page in the report (even if it's not a 'break' point)? Thanks.
|
| Detail section of report - 22" only? | 23 Nov 2004 22:07 GMT | 2 |
I need more than 22" in the detail section of my report - is there a way around this limit?
|
| Syntax Question | 23 Nov 2004 21:55 GMT | 1 |
I have a report made up of several subreports. I'm trying to add a fields in another subreport with a field in the current subreport. Below is the code I'm using with the first part being the current report. =Sum([Payment Amount]) + Reports!rsubDeposits!TotalBankDepositGrandTotalSum
|
| RE: MSFT Access Reports: Is it possible to repeat the Report Head... | 23 Nov 2004 21:21 GMT | 1 |
You can repeat the Page and other headers, but I cannot see where you can repeat the Report Header. Any suggestions?
|
| Blank Pages | 23 Nov 2004 20:26 GMT | 2 |
Why in my report is every other page blank?
 Signature Notice of Confidentiality: This transmission contains information that may be confidential and that may
|
| Limiting subreport data | 23 Nov 2004 20:08 GMT | 1 |
I created a report with a subreport, I want to limit the subreport data to each particular site, if I manually input the site number it works fine but for multiple sites the subreport returns all records for all sites. Any help much appreciated.
|
| Reports without query.. | 23 Nov 2004 20:07 GMT | 3 |
I know we can set some criteria in the query and then we can create a report based on that query. But can we do: I have a form with some dropdown fields, check boxes, combo boxes..can we create a report....just by making selections for these fields on that form
|
| Sum of non-detail records | 23 Nov 2004 19:53 GMT | 2 |
I hope I can explain this: I have a packing slip table with part number & quantityshipped. This table is linked to a table that includes comments for this record/line on the packing slip. Because it is possible to have multiple comment lines for 1
|
| using & in a string | 23 Nov 2004 19:15 GMT | 3 |
I'm trying to change a control label using a variable. The string the variable contains has an & in it ie "Research & Development" The variable passes to the lable but I can't get the ampersand to print.
|
| calculated field doesn't show the correct data | 23 Nov 2004 18:17 GMT | 3 |
I have 3 fields in a query and in a report: Aug, FAug, and AugP. In the query AugP is being calculated as follows: =IIf(nz([FAug])<>0,nz([Aug])/nz([FAug]),IIf(nz([Aug])>0,1,0)). So, if Aug > 0 and FAug = 0 or Null it should be 1 (or 100%).
|