Reports

Report that should show multiple image attachments only shows one.
I've got a table with an attachment field that I'm using to store images. I've got a report based on a query of that table plus others that works just fine except... Record 15 has two images attached, which I can view just fine in the form through the selection process. The report puts out two instances of rec... 1 Apr 2010 16:54

Sum ignoring hidden duplicates
Hello, I'm using Access 2007 to create a report that list Hotel reservations and the names of the people in the reservation as follows: Name ResNum SingRm DblRm TripleRm John Smith R234287 1 Gina Smith 'This space is accomplished with a blank ResNum Header. Alan Nelson R2353... 1 Apr 2010 14:39

Previous pages running total on the next page header
Is there a reason why you don't use a running sum on a text box? -- Duane Hookom Microsoft Access MVP "Access infant" wrote: Hi, I want to display the previous pages total on the page header of the next page. for this i used the following code. Dim bfTotal As Long ' bf stands for Brought forwa... 7 Apr 2010 15:47

Zero Suppress
This is probably very simple: I have a report that displays many columns of numbers, many of which are zeroes. To make the report more readable, I would like to suppress the zero values so that the only #'s that display are non-zero values. How can I do this? -- Peter Marshall Manager Information Servi... 31 Mar 2010 09:52

Wow what a help this guy is
Wow this Jeff character is a big help, 1 suggestion Jeff, READ. What are you 12 years old? Jeff Boyce wrote: LynnPerchance have you based your report directly on the table? 18-Jul-08 Lynn Perchance have you based your report directly on the table? Try this ... create a query against that table. In the ... 1 Apr 2010 12:24

filling a field in a continuous form with a field from a table
I have a form with the fields: date, client, atty, time, billable and description. All these fields update the Time Sheet Table. I want the atty field to automatically take the attorney's name from the table Attorney which contains one field called Atty. So for I can only figure out how to use a combo box to... 31 Mar 2010 11:00

access report
i have a combo box in a form to select 1 of 5 values and i setup list so each selection has a number value ie, 1. table 2.dessert etc. i have check boxes on the report that have to be checked based on the value selected on the form. i have to show all check boxes on the report but only check the box for the value cho... 30 Mar 2010 10:32

Page Count Error
I have a 4 page report. I use the default Page Count function. It prints: Page 1 of 3 Page 2 of 3 Page 3 of 3 Page 4 of 3 How does one correct this error? OldEd ... 29 Mar 2010 11:22

Change currency values in report.
Is it possible to change values in a report from Australian dollar to USD? The report is currently set up in Australian dollars and i would like to maybe use a form to have the USD currency value change the values in the report to USD. Is there a simple way to do this? Thanks George ... 29 Mar 2010 02:36

Some of my info added on forms fails to show up in the report.
I have tried to figure out why some flows to the report but some doesn't. I assume it has something to do with the parameters in my report set up. Is there something basic I am missing? ... 28 Mar 2010 21:12