| Thread | Last Post | Replies |
|
| Stop rounding Hours into days | 09 Nov 2006 19:08 GMT | 7 |
In Excel I can use [ ] as in [h]:mm to give me Hours/Mins and the hours will not be rounded into days once they get to 24 ? ? ? Is there a way I can have Hours displayed like this in Access, as I need to have total Hours in the end report.
|
| Not printing all records | 09 Nov 2006 18:46 GMT | 4 |
Hello. I have a report with a 2 column subreport for items in the detail. There is room for 30 items to print and I have 50 items so assumed the last 20 would go onto page 2. There is no page 2. What am I missing? It just ignores the ones that don't fit.
|
| One report based on different queries | 09 Nov 2006 18:32 GMT | 2 |
I have a report which works fine and extracts data based on yesterday's date. Now I need to be able to run the same report for a specific date the user enters, but I also need to keep the 'yesterday' option.. The date field is used as an 'or' on 5 different fields in the query.
|
| How do I prevent pg2 from printing on top of pg 1? | 09 Nov 2006 18:30 GMT | 4 |
Although "view" shows the report as two separate pages, page 2 of the report is printing on top of page 1. How do I correct this?
|
| Filtering a report by a specific criteria | 09 Nov 2006 18:28 GMT | 1 |
Hello - I’m new to Access and I’m hoping that someone can help me! I need to create a report that displays all of the issues that we have had with a particular product number in our "tech issues" db…Could someone please let me know how they think that I should approach this? Is ...
|
| Performance Problem | 09 Nov 2006 17:49 GMT | 1 |
I have a report based on only 1 table. Both the table and the report have more than 40 fields (some quite long) with textboxes and combo boxes. The performance of the report is really bad. Please help to improve it. Thanks a lot.
|
| filtering report based on subform control | 09 Nov 2006 14:35 GMT | 1 |
Hi all - would be grateful for help with the following: I have a view report button on a subform. I'm trying to set the filter criteria either on the report or in the query for the report, to show only the record currently displayed on the subform. I've put the criteria in the
|
| Picture Links | 09 Nov 2006 14:26 GMT | 1 |
Good day I have a report with links showing for my picture. In my table I put links for my picture however I want my report and form to show my picture side by side with my other content. Is there a easy way to convert picture links to
|
| Sumif in Access? | 09 Nov 2006 04:38 GMT | 13 |
Is there a function that works like sumif in Excel. I have some data I would like to calculate in a report based on the information in a field. Can I do that? Or do I have to go back to the query and use several different columns to extract the information I need? That really ...
|
| How to | 09 Nov 2006 04:36 GMT | 4 |
I currently need to set up a report that shows me a listing of peoples email addresses. What i need is to set it up so that i only have a list showing: Surname First Name Email Address
|
| Help with Report Queries | 09 Nov 2006 04:31 GMT | 3 |
I know this has to be possible to do, but I can't figure out how. Please help! I have to put together an employee hours report: - Along the top of the page will list each month. - Along the side of the page will list the different types of hours an
|
| Access - Subreport | 09 Nov 2006 03:26 GMT | 1 |
I have added a subreport to a main report and see it in Design View. When I do a print preview, I am seeing only the title of the subreport, not the content. I have Microsoft Office 2003 and am trying to create a Bill of Sale, using
|
| Adding two subtotals from two subreports in a main report | 09 Nov 2006 00:12 GMT | 6 |
I have a report called SWO R that has two subreports in it called LABOUR R and PARTS R. Both of these subreports have subtotals in them created using a text box and I would like to add the two subtotals together in the main report but I can't seem to get it to work. Does anyone ...
|
| Report won't open | 08 Nov 2006 22:36 GMT | 2 |
I have a database that uses an ODBC connection and just got upgraded to a new machine. Now, I cannot get any reports to run. I can access all table info, queries, and forms. But, the reports won't run - I can't even get to design mode.
|
| report summary | 08 Nov 2006 22:26 GMT | 1 |
I'm creating a summary for a report. The detail section lists: date, vendor, item, amount, account # I need the summary to provide amount totals by account and list the vendors that are included in the amount. In other words:
|