Re: Display Null Values - Please Help

Dennis,

First, Access will always display Null fields in a query if they are
there. However, if what you are after is to display records from a
table that is linked to a second table but has records that do not
match, that is an outer join. To create an outer join in Access, you
click on the line in the query window and right-click the line to get
to the link properties and select that you would want to see all the
records from the cim customer table and any records from the region or
group table that match.

Going back to your example, you have several issues going on. Based on
the way you set up the tables, I would think you were planning on using
the Region and Group tables as lookups. But in the CIM Customer table
you are using the Region Name and Group Name fields instead of the
Group ID and Region ID fields. You would usually have the id fields in
the parent table, link them to the lookup tables, and then use the
outer joins in the query to allow you to show the name if it is there
and a blank or null if not.

Susan Kennedy

.

Relevant Pages

  • Re: Display Null Values - Please Help
    ... Access will always display Null fields in a query if they are ... if what you are after is to display records from a ... To create an outer join in Access, ... the Region and Group tables as lookups. ...
    (comp.databases.ms-access)
  • Re: How to determine record number in recordset.
    ... ThomasAJ wrote: ... The objective is to display records in a list box and then programmatically ... I do a FindFirst on the same query and locate the record. ... Note that if the value you are searching for is an exact ...
    (microsoft.public.access.formscoding)
  • Re: CUSTOMISED GROUPING ON REPORT?
    ... >I have a report, based on a query which I have grouped on a field called ... >in the next sections i want to display records where the source = ... grouping field in the query's field list and use that in the ...
    (microsoft.public.access.reports)
  • RE: Parameter query......query!
    ... In the column of the query bring down your date field ... > My end result is a report that will display records for a certain ... > I need to create a parameter query that prompts the user to enter a ...
    (microsoft.public.access.queries)
  • Left Outer Join: Index Seek not providing all index columns
    ... We have a left outer join query which is intended to prove ... The wrinkle is that the SQL Server 2000 query optimizer is generally ... left outer join entextractitems eei ...
    (microsoft.public.sqlserver.server)