I have a report with 2 group headers and one detail section: MODULE BUSINESS DETAIL I always have module info, sometimes business info is empty, but the...

I've found code to prevent a blank report to display. However, now I need to prompt the user as to whether they want to see the blank report (one manager...

I currently use two reports so I can sort on two different fields. I would like to have one report with two fields (Number1 and Number2). From a Option...

I've looked at the posts and I can't find an answer. I really need help with this last piece. I have a subreport that provides billing distributed based on %...

I am trying to create a report that has data from two different queries that is associated by a primary key (both queries have the primary key information in...

I have a report that returns several columns of data and I would like the header to remain while the rows scroll below.

In addition. to the detail section with "District", I have one group section "Country". My report looking something like...

I have a sub-report that prints "exactly" as it should, but then repeats many, many times. The stand alone sub-report prints two pages. The sub-report in the...

It has been a LONG time since I wrote an Access Program! I'm knew my mind had dumped alot of info, but "oh my". I need prompts prior to the report opening....

Hi, I am struggling to generate reports via MS Access for a simple application I am trying to run. I have a table built that has four (4) fields with multiple...

I have a simple database with a check box, set as a Yes/No field. I need to count the number of checked boxes in my report. I have tried a few different...

Need Help!!!! Here is the example... If I have a huge table of dates and values for those dates and need to sum based on a given range, how do I sum it...

i am making a report on inventory, it comprises tblsales, tblpurchases, tblsalesret. my problem is, how can i use or read this 3 tables to make one report

Hello I know this is easy but I have forgotten how create a date range in the Query when opening a report. Meaning when I open a report I have to enter the...

Firstly, i am new to access, and secondly i am new to 2007. (Sorry for the long question / information) I have a database (MS Access 2007) that contains many...

I have a database built from scratch in Access 2007 that includes an attachment field which is used to store JPEG photos of people's faces that are printed...

I am trying to generate reports for each unique Person in my database tables. How can I write a query that produces a report for eahc ID on a separate page...

I have a report that shows the results of several queries that all use the same parameters. The user enters the parameters (2 dates) through a form I have...

What am I doing wrong that I have forgotten or is stupid? I am creating a recordset in the report I have created a textbox called 'txtCase' in the...

I have a report that is over 500 pages long but I need to put in page breaks that separate the "sections" - each new section needs to start on an odd page...