I am using Access 2000 and am having trouble generating a report. I created an unbound form that prompts for criteria for the query associated with...

My report contains about 6 sub reports. However when I preview the report it shows the 2 pages correctly but then repeats these pages over so that I end up...

I have a macro that opens a form & gets a combination of user input along with data from a query that the form is based on. I would like one of two reports to...

I have just had a new computer installed with WinXP/MediaCentre2005. Previously I could fax directly from Access2003 reports, but now I can't. The system...

Is there anyway possible to set the record source property of a sub-report programatically for each record of the parent report? Due to what seems to be a bug...

I need some ideas on how to solve a problem. Excuse me for the length of the post; I’ll be as concise as opssible. I need to create a report in which weekly...

plz help me with your code can you plz write a criteria for the below conditions: i need more help from you for this condition, As i am new to programming...

I have an expression to sum three values from a linked (to Excel) table. The expression was built with expression builder but the reports prompts for "enter...

I created a report based on a table of property listings. Under one location(say #15), there can be many buildings(A, B, C, etc). I needed an overall sum of...

How do you add a pie chart to an Access report? Thanks Don

Dear all, Access has built-in function to export report into Excel. But for report which has grouping, the result is messed. Is there any better solution for...

I have a report which contains a subreport. The report is grouped by Student ID, and I have the subreport in the Student ID header section. Sometimes, there...

I have a report that groups teams together. Each person within that team has a score which is subtotaled for a group total. How can I sort the teams by this...

Hi All, I have a date conversion problem. 1. I've calculated the difference between dates from field#1 and field#2 2. I want to add 90 days to the...

When i run my query i've realised i got negative numbers.So i'd would like to change the color for the negative numbers numbers to red.And the positive ones...

i have a report with 2 sorts and 2 footers. i need to count unique values over the whole group. i can use a text box control to =1 and sum over group option,...

Hi, I'd like to set the distance from Top of a subreport at Runtime, depending on the contents of a Detail field I've tried the code below plus variations ,...

I have a report with 5 subreports. I believed I had built them from the same template but one of the subreports show up in the report even if it has no data....

I am asking for more help because I really need it. I have a report with a subreport in it. The page format is as follows: Product ID I would like...

I have a report that lists how many times a day a driver delivers another load, I would like to count the number of days in the report it could be three days...