Possible Report Issue

Hi. I'm working on a database for a safety audit. The auditors would like to 
be able to use some of the tables and subtables as a sort of checklist for 
the audits. The table/subtable structure is as follows:

Topic
  -->Subtopic
    -->ProgramArea
      -->ProgramRequirement

I decided to create a report that will output that data. However, the report 
is only outputting information if there are ProgramRequirements already 
entered for a given ProgramArea. Is there a way to get it to output the 
ProgramArea and ProgramRequirement even if blank? Or am I going about this 
the wrong way?

Thanks!
Eileen
0
Utf
12/10/2009 9:21:01 PM
access.gettingstarted 618 articles. 1 followers. Follow

1 Replies
1093 Views

Similar Articles

[PageSpeed] 3

The problem will be with the query that forms the RecordSource for your 
report.  You'll have an "inner join" between two tables somewhere, and that 
only returns results if there is a match.  If you open the query in Query 
Builder and double-click the join line(s), you'll see other options ("outer 
joins").

Phil, London

"echofuzz" <echofuzz@discussions.microsoft.com> wrote in message 
news:62D28718-14AA-42CA-900E-52A66272139F@microsoft.com...
> Hi. I'm working on a database for a safety audit. The auditors would like 
> to
> be able to use some of the tables and subtables as a sort of checklist for
> the audits. The table/subtable structure is as follows:
>
> Topic
>  -->Subtopic
>    -->ProgramArea
>      -->ProgramRequirement
>
> I decided to create a report that will output that data. However, the 
> report
> is only outputting information if there are ProgramRequirements already
> entered for a given ProgramArea. Is there a way to get it to output the
> ProgramArea and ProgramRequirement even if blank? Or am I going about this
> the wrong way?
>
> Thanks!
> Eileen 

0
Philip
12/10/2009 9:27:13 PM
Reply:

Similar Artilces:

Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...

Personal Folders in OWA
Hello, I have just enabled OWA on our Exchange 2003 SP2 through ISA Server 2004. Is there any way to access personal folders in OWA? Thanks in advance. If by personal folders you mean .pst files, the answer is NO! Sorry. C C wrote: > Hello, > > I have just enabled OWA on our Exchange 2003 SP2 > through ISA Server 2004. Is there any way to > access personal folders in OWA? > > Thanks in advance. > > "C C" <someone@atsbcglobal.net> wrote: >I have just enabled OWA on our Exchange 2003 SP2 >through ISA Server 2004. Is there any way...

Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something happened and I probably did it, that causes the statement downloads not to go directly to the account. Rather they want to be saved in a file and then opened into Money. I then have to delete the download. I have tried several things in order to fix this: 1. I verified the file associations of OFC, OFX were correct. They were. 2. Lowered all my security settings in IE. Even put banks into Trusted site zone. No go. 3. Made new accounts. Didn't help. 4. My IE cache is large (500MB) and regularly cleaned out. 5. I made s...

2008 R2 Reporting Services would not start
after i upgraded from SQL 2008 to R2, the reporting service no longer start and with error "Default appdomain failed to initialize". I tried to remove the reporting service and reinstalled and it didn't help. I even tried to remove entire R2 and reinstall that way, didn't work either. now, i'm clueless... please help! thanks I am experiencing the same issue. Did you manage to figure out the problem? CK wrote: 2008 R2 Reporting Services would not start 26-Jun-10 after i upgraded from SQL 2008 to R2, the reporting service no longer start and w...

is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form. The form is based on a query, so when I open the form, a pop comes up where I enter in what I want to query. So instead of 30,0000 records, I get 1-10 records. on the form, I have a text box. I want to be able to enter in what I want to query next and afterupdate have the recordset/form reload with that query instead of my original qeury. I figure this has to be done with VB. I am just starting to learn some VB but I am lost. Any info would be great, thank you. It does. You need to apply the new query or table name, or the sql string to the forms recordsource, then...

XP/vista scan resizing issue
i recently changed from XP to vista, and since i changed i have had some issues with scanning full A4 pages. in XP the pages i scanned automaticly fitted directly into the document (an A4 scan was still full A4 in word). But in vista it automaticly resizes the scan to fit inside the "writing frame" (the middle of the paper, like 3cm from top and sides) is there any way to change this without having to change the "writing frame" size every time i want to scan a document? i think i used same version of word then as i do now (office 2003) and i still have the sam...

Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load method, is there a way, later on in execution, to easily determine if the XmlDocument object has changed from the original version loaded? I'd like to be able to check a condition to see if the document in memory has been editted (i.e., nodes added, attributes changed, etc.) so that my user can decide whether or not to commit changes to the disk file before moving to another file. Will I have to resort to re-loading the file, and comparing OuterXml properties? Gabe Gabe Covert wrote: > I'd like t...

Changing the source of a report
If I have generated a report with a given table or querry and I want to keep the format, but change the source (table or querry), how do I do that? -- See me for who I am and not who you want me to be,. That way no one gets disappointed! Assuming the form (or report) is open, you can use Forms![NameOfForm].RecordSource = "NewQueryName" or Reports![NameOfReport].RecordSource = "NewQueryName" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Lisa R" <LisaR@discussions.microsoft.com> wrote in message news:08...

Export report templates
I would like to export the standard and modified reports from Great Plains 6.0 and am not familiar with this application. Is this feature available for both FRx reports and the vanilla standard reports that come with Great Plains. Any assistance in how to obtain this information either in a text, csv format etc would be appreciated. For FRx, you can export to Excel and other formats. Within FRx you would go to the Report Catalog and pick the report you want to print. On the output tab select the type of destination you want. Click the Generate report button. There are no vanilla repo...

Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The Office Table contains a Year, Year To and From [financial year] and the other fields are the 5 membership types (regular, student etc) and these 5 fields contain the different amount each type of member has to pay. I want to create a form whereby on entering the financial year and the membership type the correct amount is automatically inserted into the 'Amount' field: FinancialYear - in current form = OfficeUseOnly SubsFinYear and then if MemberType = 'Student' find Student field ...

Report by Year, Qtr and by Day
How can i create a report by Year, Qtr, day using pivot? Is it possible? I have 200,000 data on my clipper program, and it has all the details by date, can i use pivot to summarize report by year, qtr, day without programming... Thank you so much! Hi Rommel, Drag the date field onto your pivot table as a row or column field, then right-click it and select 'Group and Show Detail' from the drop-down menu. Should be easy from there, Go to http://www.edferrero.com/tutorials.aspx for more info. Ed Ferrero http://www.edferrero.com > How can i create a report by Year, Qtr, day...

Report Error
Hi We are receive the following error message when running the Account Overview Report. Error:Subreport could not be shown. This only occurs when we run the report for 3 of our accounts. The report for all other accounts runs fine. We have noticed that there are some inconsistencies within these Accounts such as Open Service Activities associated with Resolved Cases but we do not think that this could be the cause of the problem. All the reports share the same data source and all users have the appropraite permissions. We do not know what could be causing this? Would someone be pre...

Design issue; and finding and displaying row on other workbook
1. An academic course is divided into two sections: lecture and discussion. The lecture section contains all classes, but the discussion classes do not. The discussion section is further divided into three subsections, each containing multiple classes. The need is to coordinate student attendance and grades for all sections. Currently we have 1 lecture section workbook with all student names, IDs, and other info; and 3 discussion section workbooks with the same only for the relevant subsection. And then there is a consolidation workbook where lecture and discussion are put together and attend...

pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or various other shapes than just squares and rectangles? Thank you ahead of time. with a graphics editor -- Rob Giordano Microsoft MVP - FrontPage "Stephanie" <Stephanie@discussions.microsoft.com> wrote in message news:014D0D06-15F9-4D92-8D93-64FBD3A9CA32@microsoft.com... | Is it possible to insert a picture and make it into a circle or an oval or | various other shapes than just squares and rectangles? Thank you ahead of | time. | | Stephanie wrote: > Is it possible to insert a pict...

OWA login issue for one user only
I have only one user who cannot access OWA on Exchange 2007. When he logs in, he gets the following: Request Url: https://%OWA SERVER%:443/owa/lang.owa User host address: %IP ADDRESS% Exception Exception type: Microsoft.Exchange.Data.Storage.StoragePermanentException Exception message: There was a problem accessing Active Directory. Call stack Microsoft.Exchange.Data.Storage.ExchangePrincipal.Save() Microsoft.Exchange.Clients.Owa.Core.RequestDispatcher.DispatchLanguagePostLocally(OwaContext owaContext, OwaIdentity logonIdentity, CultureInfo culture, String timeZoneKeyN...

Capital gain reports
Can someone explain to me why in Money 2004 capital gain distribution transactions are listed as loss. Makes the report unuseable. Henryk Birecki ...

Invalid Sub-Total and Total in POP report
Hi, We've a user that came up with a POP Purchase Order Blank Form report (it's a customized version, but there was no changes since quite a while and has ever worked fine), on which the sub-total and the total is incorrect... On the screen, the POP shows 2 line items with a line value of 1305.00$ for the first and 1044.36$ on the second line. Both lines have had a receiption against it. When printing the report, the sub-total shows only the total for the 2nd line and the total line is @ 0$. I've ran a Purchase Order Documents reconcile, but this had no effect on the ...

VS 2005 Using Crystal Reports from MFC application
I'm trying to find documentation on how to integrate Crystal Reports (the one included with Visual Studio 2005) into a C++/MFC dialog based application. Has anybody had any success with this? If so, do you know if I have to use managed C++ in order to accomplish this? I tried to add the CrystalReports ActiveX ReportViewer (10.2) into my dialog but it doesn't appear in the list of available ActiveX objects. I looked into the Registry to see if the component was actually registered and the entry is blank (HKEY_CLASSES_ROOT \CrystalReports102.ActiveXReportViewer.1 is empty). Does any...

Is this possible
I want to make a list of the files in several different folders. Is it possible to somehow "Copy and paste" just the filenames into a list, in either Word or Excel or Wordperfect. I am just trying to sort the files in several different folders to weed out duplicates. There has got to be an easier way then typing them all or screen printing the lists and manually weeding them out. Any suggestions. Frustrated... Hans, Here is some code that will start in a directory and list all files in that and any sub directories. It uses recursion to go through all the subs. Just ch...

Access 2007 Report Question
We have an a main equipment table that shows multiple pieces if equipment and current location. Is there an easy way to create a summary report which shows the current total for a specific item at a specific location? If you set up a grouping report. It may be necessary to create a grouping/totals query first on the table and use that query to create your report. The report wizard should give you a way to summarize the information with a count. "Rex Mundi" <jimb424@gmail.com> wrote in message news:5b1f06b3-dec5-4bb6-a539-59886fc7f140@v29g2000hsf.googlegroups.com... >...

Odd issue with Excel 97 SR-2
Hi: I was wondering if anyone has any ideas regarding a problem I am encountering with a colleague's Excel that she is running. Anout 9 months ago we upgraded to XP an since then she has had severe problems doing basic tasks. Often she gets error messages staing that her clipboard is full and then she can't cut/paste. Lately when she goes to open a doc Excel can not find the directory and she has to go through Windows explorer to open something. Our tech dept. (we are a remote office) is at a loss and we think we have to just re-install office. If there are any ideas we would app...

Inventory Turnover Report
I added OrderPointQty and OrderUpToLevel fields to the Inventory Turnover By Site. I entered the restriction with Item Master Locn code = Item Quantities Locn Code but the values in this field are incorrect with and without the restriction. Yet there are numbers in these fields but they show the number when "Initial Values" is selected, not the site. Also, why are the minimum and maximum fields on the Qty/Sites screen but the previous version of GP put these amounts in OrderPoint and OrderUpTo? I can't seem to find all the setup info I need in the User Guide, it doesn'...

Easy reporting question
Is there a way to find out - The total number of e-mail items in a store? ...

Is this Possible ?
Hi Have a newsletter document with text boxes that have no outlines but internal gradient colour fills. Is it possible that a macro could remove all colour fills in one hit just leaving the text in place ? many thanks Dim oShape As Shape For Each oShape In ActiveDocument.Shapes If oShape.Type = msoTextBox Then If oShape.Line.Visible = msoFalse Then oShape.Fill.Visible = msoFalse End If End If Next oShape should clear the fill from text boxes that are filled and have no border. -- <>>< ><<> ><&l...

Using secured mdb with crystal report
I tried to display a crystal report but error "20535:incorrect session parameters" is shown. With a non-secured file that work perfectly. The lines I wrote are: CString szEmpty; CString szPassword; szPassword = _T("\n") + pDbReport->GetDatabasePassword(); pTable- >SetSessionInfo(szEmpty.AllocSysString(),szPassword.AllocSysString()) ; some extra details: crystal report 8.5 Visual studio 2003 office 2007 I think 'SetSessionInfo' has two arguments that are id and password. But, you push password parameter with _T("\n"); Why you do it? is right you...