Hello, I had a similar question, but a little different. This post helped me fix the problem, so I thought I would add a note for others. If you are trying...

I have a report that displays jpeg images to the user. The user has an option to email the reports to themselves. The jpegs are typically 600kb each....

Subreport - rItem Text Box name - rItemTotals Control Source - =Sum() Main report - rTotalPrinter2 Text Box name - Text87 (in report footer) Control Source -...

I am running Access 2003. I have a report, listing incidents our officers respond to. The data comes from a query containing 8 tables. One of the tables...

Hi experts I have a number of clients (in table = tblclients) and an e mail address stored on this table (clientemail). Each week I send them a report (named...

How do you attach a table in Design View?

I have a report for overdue invoices grouped by day with a 30 day interval. I want to label the groups e.g. Less than 30 day, 30 days, 60 day, etc. How can I...

I have designed a query which gets its paramters from a form. The form contains a drop down combobox with names. a use selects a name and the query brings up...

I need two totals in my report footer. The first adds the field , and works fine. The second is intended to also add the field , but only where the checkbox...

I am trying to create a cheque through reports that has details showing the invoices being paid and a cheque body at the bottom. I got the query to run so...

I'll do my best to describe the problem without sounding like a bafoon. I have 2 tables: Properties and Units. Each one property has many units, hence a...

If it helps anyone, here is the formular you can enter into a query date field to pull previous weeks data: Between (Date()-Weekday(Date())+2)-7 And...

My data source for my report involves calculated fields in a query with expressions such as: INS FEE: FormatCurrency(IIf(=!DATEPAID,!,Null)). Now all I want to...

I've designed a report with a header which has a special title that it depends on a previous form's textbox In the header page I used a textbox ...

Hope someone can help - am fairly new to all this so go easy on me please... I have created several subreports which work fine by themselves but when used in...

I have a drop down list set up for a report where you can select between 9 different regions as to which you wish to view. Would like to add an ALL to the...

Hi, I hope someone can give me some good suggestions. I have an Access 2003 (Access 2000 format) database. I would like to speed up my report(s) but I have a...

When I use a combo box in a report it displays the index number instead of the value in the lookup table. How can I get the value to display instead of the...

Hi guys, I'm struggling with a problem I'm having. I have two fields on a report, one called Customer_Supplier which can have a value of lets say for instance...

I need to have default values in a report. I have the default value in my tables. I created a query from which the report is based. The default value does...