I make many financial reports and I am having trouble making the percentages work properly on group total lines. The totals sum up many detail lines and work...

My report is using only 2 columns; "Supplier" and "=Sum()" to total NCRs per supplier. Each supplier has multiple NCRs and so I grouped to show the name only...

I'd like to print the first record of a group to the Page or Group header, but not print that record again in the detail section. How's it done? Thanks, Bernie

I have a standard Access 2007 report (based on a query) in my database that pulls information on a specific item. The report runs fine but when the user...

I need to copy a report to create a second report, and am looking to know how to globally change formulas to a different table/query. The fields in the two...

Hi! Please bear in mind that I am still learning the ropes in the Access worlds, so pardon my lack of terms. Here's my question. I want to create a forms...

I am using conditional formatting for the backcolor on some controls in the detail section of the report. When I view the report in Print Preview, the...

I have a Query that only pulls in two fields of a table, one hidden and one visible. The visible one is a date range that starts 1/1/2010 and ends 5/8/2010....

I am using Access 2002. I have created five reports that list totals in the footer of each for January through December. They are then all on a report so...

I'm not sure how to describe this. I am trying to create a report that lists the organization by organization results of a survey we did. We want to be able...

Below, I've inserted a copy of a posting that was helpful to me. I can now print a report for each record in my form even if the subform is blank. However,...

I have a text box in a report linked to a 'memo' field in an access table. The text is in the vicinity of 3kb so that returned on the report is quite large,...

Does anyone know if it is possible to email an attachment which is not one of the available Object Type formats of the SendObject action (.xls, .rtf, .html...

I know you can use the Printer.PaperSize = acPRPSUser to setup a custom page size in access, but then how do you actually set its size? The problem I have is...

How do you programmatically change the sort order of a report? If I have a form with option buttons to select the sort order, how do I pass that parameter to...

how do i refer to a dynamic field name please. I have fields month1, month2, etc and only want to print the value for the current month Something like =val("...

I'm designing a response card for a mailing and I need to include some check boxes next to some text boxes. How can I do it, short of adding an empty text box...

I am having difficulty adding controls to a report. I am able to create the report as follows: Set rpt = CreateReport With rpt .RecordSource =...

In Access 2000 I created a new report which has to show the contents of a memo field called . The query shows all of the data, which can be 300 or 400...

Hi, I was wondering if I can get some help with Access report question. In an Access report, There is a number of headers namely Agenda Header, Task Header...