Re: Null Expression

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
Date: Fri, 25 Jul 2008 16:06:44 -0400

Steve wrote:

I still have the same problem. How do I create an expression so that
all of the locations are indicated even if their data is null?

I think you should post a few rows of sample data from each table
(just the relevant fields to illustrate the problem - invent some
data). Follow that by the results you want your query to return from
the sample data.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.

References:
- Null Expression
  - From: Steve
- Re: Null Expression
  - From: Jeff Boyce
- Re: Null Expression
  - From: Bob Barrows [MVP]
- Re: Null Expression
  - From: Steve
- Re: Null Expression
  - From: Bob Barrows [MVP]
- Re: Null Expression
  - From: Steve

Prev by Date: Re: Null Expression
Next by Date: RE: Query Help Again
Previous by thread: Re: Null Expression
Next by thread: Re: Null Expression
Index(es):
- Date
- Thread

Relevant Pages

Re: Select DISTINCT...wont select DISTINCT
... used both DISTINCT and Group By in your original query seem to highlight ... DISTINCT guarantees distinct _rows_, not distinct fields. ... Can you show us a few rows of sample data that exhibit the problem? ... This email account is my spam trap so I ...
(microsoft.public.access.queries)
Re: LEFT JOIN problem
... Mary, assuming you are bent on using dynamic sql, and assuming you don't ... If your sample data is incomplete, and you really do need a left join, just ... Is your sample data incomplete? ... This email account is my spam trap so I ...
(microsoft.public.inetserver.asp.general)
Re: Sub-Query Problem
... I think you need to show us some sample data and ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.access.queries)
Re: creating an effective search result
... mark | r wrote: ... >> few rows of sample data (just the minimum number of fields to ... Please reply to the newsgroup. ... This email account is my spam trap so I don't check it very often. ...
(microsoft.public.inetserver.asp.general)
Re: date ranges
... And if the query works as desired, what should the results look like, based ... on this sample data? ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.access.queries)