Hi, I'd like to be able to print a report that prints the top 3 of each group. However, when I try modifying the SQL to begin with "SELECT TOP 3", I get only...

Hello, I have a report that is bound to a query. In this query I am using 3 different tables. Kit, Solicitations, and Postings. In the Kit table I have...

1. Is there a way to get the SendObject command to read email addresses from a table? 2. Is there a way to seperate a report so that each header gets...

I am trying to get a Grand total of my subtotals in my report.. How do I Total all of the subtotals? I have them in the Report Footer, the only problem is,...

I have a report that has a subreport in the footer. I need the report capped at 28 rows per page because the subreport (rotated 90 degrees with the rotated...

I EXPLAINED IT WRONG ON MY OTHER LISTING! I have a report that has several rows and colunms as follows. I have it set up if a check box is true to show the...

I have a report that has two fields called "ManifestNumber" (number field) and "RecievedOn" (Date/Time). Then I have another form with two buttons. "Print New...

i have been trying to add a button so i can print a report based on the current record in my form.... what i have so far is Me.refresh DoCmd.OpenReport...

I have a union query in access 2002. The first two fields are SortKey amd RecordType. I specified OrderBy = SortKey, RecordType. The data comes out just as I...

How can one insert a columnar sub-report (established by using Page Setup) in the Detail section of a report where other Detail fields need to be...

I have 2 tables, one is the CustomerInfo and the other their Transactions. I have a form which shows individual CustomerInfo from the CustomerInfo table, and a...

I have a report that prints several pages of information for each record. I would like to have a "Page 1 of 6" footer at the bottom of each page, but I want...

I create a form and a button on the form. When I click the button, the code would send information to the report to be printed out. However, data show up on...

I am using Access 2002 and the Label Wizard. I use a query as input and the table with the data has the input mask set for the 9 digit zip. The query output is...

Hi, Just wondered if anyone had any examples or knows how to do the following with Reports; I have a Room Booking System and want to display on a report (or...

Hi I have a report that uses a paper size of "cheque". When I preview the report, it comes out as "cheque". But when the front-end is distributed, the preview...

Dear all, At the Detail_Format event, can I know the last record of each page ? After the last record, I want to add something. Please let me know the...

Hi all, I have an invoice report which contains 2 subreports. Normally, everything fits on 1 page. But in those instances where either or both subreports...

I have an Access Report where I would like only the last 4-digits of the SSN to show when printing. I have already used the...

I am working to implement a very specific design for an Access report that needs to be saved as a pdf file. With Stephen Leban's excellent function I was...