| Thread | Last Post | Replies |
|
| Access Report -limited 22" - I need 30" for plotter | 15 Nov 2005 18:44 GMT | 1 |
I need to move the report out to 30" not just 22". The plotter work in 30" with excel.
|
| Displaying Print Preview Neatly | 15 Nov 2005 18:16 GMT | 2 |
I am using a print preview instead of a continuous form to display selected records with linked images. The user will select a parameter from a combo box-- region 1, region 2, and so on. My questions are: 1. How to I pass the parameter that the user selected from the combobox ...
|
| Adding field values together | 15 Nov 2005 16:42 GMT | 4 |
Hi. I'm having a silly problem when I try to add the values in a series of text fields together. Each of the text fields (set to format General Number) is fed from a DLookup like this: =DLookUp("TotalPlacements","qrySECCountOfPlacements","[SchoolID] = " &
|
| Counting unique values in a report | 15 Nov 2005 15:16 GMT | 9 |
Hello, I want to have a text box in my report header displaying the number of customers appearing in my the query result that underlies the report. The query is called qryOrders and the field I want to count is Customer. I have for example 20 orders from ten customers. Can you ...
|
| Excel | 15 Nov 2005 15:08 GMT | 1 |
Output MS Access report to excel and keep all formatting
|
| multiple crosstab in report | 15 Nov 2005 14:46 GMT | 1 |
I have been trying to create a report based on several queries. The first query is a crosstab that gives me counts by state and color. from that crosstab, I have create and a 2nd and 3rd query which calculates a percentage based on the total count from query 1. Each query ...
|
| Report design question | 15 Nov 2005 14:45 GMT | 4 |
I am creating a detailed Sales Journal. I have a "Net Sale" field from a query. I also include payment terms (cash, check, credit in check boxes) in the same query. On my report, I would like to like each line to display the "Net Sale" in the respective "Cash", "Check", or ...
|
| Why is the text in my memo boxes being truncated in my reports? | 15 Nov 2005 13:55 GMT | 4 |
I'm working on a database for work that involves creating multiple unique reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was ...
|
| subtotal on a group in a report | 15 Nov 2005 13:39 GMT | 6 |
I haven't been able to find a way to subtotal a group correctly in a report. My report is using a query that has two tables joined. First table is a Stock Type Table and the second table is a Transaction Table. The first table has the original # of shares and the second table ...
|
| conditional calculations (iif) | 15 Nov 2005 05:25 GMT | 15 |
i have a report based off of a query that is created from user-input from a form. i'm trying to add a text box to show the value of a field in a table that's not part of the original query's design. so: form "frmparameters" lets the user fill in 5 parameters to construct the
|
| MS Access Reports | 14 Nov 2005 23:35 GMT | 1 |
How do you highlight the first record in the detail section of a report. The report has multiple groups, and field footers. I would like to be able to show a text box on the first detail record only, of each group.
|
| How do I hide inactive records when creating a report in Access? | 14 Nov 2005 21:24 GMT | 2 |
I have a database of student employees. A co-worker of mine needs a list of the employees by room number. I have created a report for her, but I want to hide the records of inactive employees, and I can't figure out how to do this. I don't want to delete them from the system, ...
|
| Totals | 14 Nov 2005 21:04 GMT | 2 |
I have created a report with a sub report. I would like to add a Total field in my main Report Footer that calculates the sum of a field in my Sub Report. I thought I could get away with:
|
| How do I sum a total from multiple sub reports onto a main report | 14 Nov 2005 20:35 GMT | 6 |
I am trying to sum amounts contained in sub-reports on to the main report that contains the sub-reports. Is this possible? If so, does anyone know what the syntax is? thanks
|
| Print page footer only when needed | 14 Nov 2005 19:57 GMT | 9 |
I've got a report that may or may not exceed one page, including the report footer. I would like to include a page footer on the first page only if the report exceeds one page. I set the report PageFooter property to "Not with Rpt Ftr", which prevents the page footer from ...
|