Re: Pull report with or without relationships

SharonInGa wrote:

>The relationship in my database is:
>Employees Profile Table: One --- to Many: Applications Table
>
>My customer wants the report to show the Employee Profile with applications
>if applications exisit OR the Profile alone.
>
>Currently, the profile ONLY appears if there are assigned applications.
>First, Is this a relationship question or a VBA question that will pull the
>profile whether or not it has assigned applications. I do need to maintain
>the one to many relationships between the two tables in order to run all the
>other forms and reports.


It might be a relationships issue, but it's definitely an
issue in how the tables are joined in the report's record
source query. Currently you have an INNER JOIN, but you
want an outer join.

Select the connecting line between the two tables, right
click on it and then select the Join Type - Include all
records form the Profile table and any matching records
from the Applications table.

If you do that in the Relationships window, it will be the
default join for any new query you create using these two
tables. However, you'll have to recreate (or modify) your
existing query.

If you change the join type in the query window, it will
have no effect on other objects in your database.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: XP Roaming Profile Issue
    ... This behavior is because the applications are installed either by another ... The profile ships up and down to the ... > For example if they sit at a newly imaged machine and installs all their ... > with the user and is poulated with the respective application settings. ...
    (microsoft.public.win2000.active_directory)
  • Re: Duplicates In Concatenation
    ... If you are seeing too many records in your report, ... >> Make the query into a totals/group by query. ... >>> a profile for a former employee. ... >>> Function To Concatenate Child Records') so that I can include several ...
    (microsoft.public.access.reports)
  • Re: C++ inlining as a multithreading optimization tecnique?
    ... > If we have to work with applications in which threads aren't I/O ... > My opinion is that we could use inline as a mechanism to improve contex ... Restoring a thread ... The only answer that we can give is profile, profile, profile. ...
    (comp.lang.cpp)
  • Pull report with or without relationships
    ... My customer wants the report to show the Employee Profile with applications ... Is this a relationship question or a VBA question that will pull the ...
    (microsoft.public.access.formscoding)
  • Re: Start up in XP Pro
    ... For user logon applications are managed by the profile ... profile under documents and settings. ... > depending on what config you wanted. ...
    (microsoft.public.windowsxp.security_admin)