How can I show the "last" date of a record in a report? There are many entries for one establishment, but I only want to show the last date...

How do you get rid of the blank spaces in the report after choosing "yes" for hiding duplicates?

Hello, I have a group in my Report. I want a field to show up in the group details if the return value of the group is Red, but not Blue. I hope that...

I have a report that displays a column of eiter 'yes' or 'no' for each record. I would like to total (count) the number of 'yes' records. Tried '=count() but...

I had a report that contained vertical text boxes. Upgraded to Access 2003 and now the text boxes are empty. I found a MS KB article (839779) that acknowledges...

Hi, I want to subtotal data per page. It works correctly to subtotal the groups and the report, but the page subtotal returns #error for both count and...

I have a column in a table linked to a series of bitmaps. These show up as a package, no problem. Double click on them and I can view the pictures,...

Hi folks: I have a rather challenging (for me, anyway) reporting requirement and would appreciate any feedback. In short, I am trying to create a multi column...

I created the report in Landscape view and it still opens in Portrait view. I checked the page setup, and it says that it is Landscape view, but the...

I have 5 identical reports, the only difference in the reports is the text in the Report Header data in details area is selected from a query...

I am new to Access and seek your help. I have a database where I have entered Client Name, Product Name and associated Funds. Also entered in the Date on...

I have made application in Access 2000 using a complex form for Data entry and creating a complex report based on a dozen of linked tables and several dozen of...

I am trying to print totals on a report which contains a sub-report. I want to print one line of totals in the report footer which shows totals from columns in...

Hi In my report I'm trying to sum a field only where the date is less than 1/1/2004. This is what I typed into the control source of the text box: =sum...

I have a report which lists products that have been ordered by customers. To improve readability, I'm trying to get the report to print with alternate shading...

Hello. Not sure if this is a report question, or query question, but here's my problem. I have several yes/no fields in a table, for example, Quote Declined,...

I currently have 6 new Dell computers all with XP-OS and Office Pro 2003. Only one of them will open/edit/print Reports in Access. All the user accounts are...

I have one column of data (say 10 items) that I would like to format into columns of 5. How do I do this?

Im having trouble displaying the query data on my reports. I have figured out how to display one set of the data, that was 'site name', however when trying to...

I am using a macro to active a report and I need help to set up the where condition. I have a multiselect listbox in a form and a user can select one or many...