There may be a simple answer to this but I just can't figure it out. I want to add up data that appears in, and is specific to, the group header of a report...

I am trying to create a report using wizard. I dont see the button for 'Summary Options'. I was reading another post and I understand that the fields wanted to...

I want to introduce some summaries like sums and averages over my detail records and group footers. I know I can do that by creating text boxes and filling in...

I understand that you cannot calculate an unbound on a report, but my attempts at calculating on the original source isn't working either. I need the average...

You must size your Image control to the dimensions of the original Image and then set the Image control's SizeMode prop to Zoom. For your second issue, there...

I am having the same issue as Tammy. I ckd the website below but did not find a solution that applied (maybe I did not look in the correct spot). My report...

I have a column of numbers that I want to average, but I don't want to include the records with $0.00 value in it. I currently am using: Avg() in the group...

I have a report with a field . This field is labeled "Separation Date:" The report has only one record per page. Can hide the label if the field itsself...

Hi, I'm trying to get Access to show the column headings only once compared to showing them once per group. A believe it is a rather easy matter but...

Having been growled at for being unaware of protocol I have taken advice from an MVP before sending this. If this offends protocol I apologise in...

Duane - I'm trying something similar with no luck: =DateDiff("d",,) =SUM() but when i run the report, i'm asked for the value of the TravelDays...

B: The On Activate event fires in a report only if it is previewed. So, you could do the following: 1.) Dimension a variable in the report's general...

Hello All, I have been researching this question going on 4 days. (3 to 4 hours a day at work) I am designing a database with Access 2003 to track the movement...

Hiya, fellas I've a report like this: REPORT HEADER+++++++++++++++++++++++++++ TripJob TravelDaysTotal (=Sum()) PAGE...

I have created a report that prints out customer invoices and totals their cost in a field called CustTotalCost. I am wanting to get grand totals for all...

I have an Access DB set up with linked tables to the Backend DB. When users try to use the DB, it keeps giving an error that the DB is already...

I am trying to create a report of staff qualifications. I have created the first step in that I can count how many employees have particular qualifications at...

I have this app distributed to several desktops throughout the company. On 1 and only 1 desktop, when the user tries to analyze a report with Excel and export...

I have a report that depicts the way in which a value compares to another value. Specifically, it compares sales one year versus the prior year and the prior...