can i sum some data with its repetions as for example 100 100 30 it gives me 130

My report is run on a table that brings in "Downpay" and "Sales" for each "AgentCD". I want the report to be sorted based on a calculated field that is a...

how do i set up the report to show the calculated values of each month from the table so I have a total number showing for each ID in my reports. The help...

I have multiple reports I need to automatically send in an email to managers. All these reports are based off of queries that have criteria, which require...

I print Gift Certificates for my Business. How can I place a Consecutive Serial Number on the report?

When sending out customer orders I today include an invoice and a packing list printed from MS-Access. However, I would like to add various information to...

My option group displays in print preview but doesn't print on the hard copy.

I created an Access report with lines drawn under column headings and group headings. When I export to Microsoft Word, the lines disappear. Is there...

I have an access report that I have placed a text box in one of the group headers and it is only showing 255 charecters. If I place the same text box in the...

Hi, I have some simple calculations being displayed on a report using Sorting and Grouping. This is working fine. I also have on the Report Footer giving me...

Hi all, I was wondering if there was any possible way to do something like the link below in a report? If so some tips or tutorials would help immensely. I...

I have a report which groups by Dept, starting a new page for each dept. I have added subreports based on cross-tab queries, which show data by month/year,...

I have a crosstab query that works great. But I need to print out a report. The fields in the query do not change, just whether there is data or not. ...

I've printed an access report with a hyperlink to a pdf using desk pdf. Shouldn't the hyperlink be active in the pdf?

Hi, ich have a Report with a recordsource. the source is a query. when call the function Me.RecordSource, i get the queryname. is there a possibility to get...

Hi All, I am creating a report based on a query. I have a prompt to ask for the Beginning Date and the Ending Date. When I run the query I get the correct...

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...

Hello, I have a report that shows in a text box page 1 of 22 for the first page 2 of 22 on the second page etc. This works great but, I want to reset the...

Hi, The report has PCODES header and PCODES footer. I used the textbox to create the COUNT() at the PCODES' footer. At the result, I got 3, 4, 2, 1,...

Hi, need some help. How do I make a report acept multi query results. I want a report that retrives results from several queries. How can I make this...