How do I see Null Values in a field that is text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that has a text field. I'm trying to count the fields. I get
the answer I want, but if the field has a null count, the field does not come
up in the query. I want the field to show up even if there is no value.
 
"trying to count the fields" "field has a null count" "doesn't come up in
the query" "I want the field to show up"...

Do you mind providing some sample records of what you have and what you want
to see in your query?

--
Duane Hookom
MS Access MVP


"View Fields if Value is Null" <View Fields if Value is
(e-mail address removed)> wrote in message
news:[email protected]...
 
Sure, I can provide you with an example of what I’m doing.

Query:

I have a table with several field names

In the Design view:

Field Name Field Name Field Name Field Name
SECNAME MEMBER RANK_FILE RANK_FILE
Group By Group By Group By Count
Ascending

The Answer:
The answer gives me what I want, but I've typed my problem below:

BAY AREA 64
CAPITOL 8
EUREKA 6

Without going any further…here is the dilemma:

Above, I’m counting the number of members in a section that are of a certain
rank. In the answer I receive the names of the section and the counted
members within a certain rank. The problem is, is if a section does not have
any members within that rank, the section does not show up, i.e., the section
name BISHOP which should appear. The reason I want this is because in a
report I’m trying to put together, I have 17 sections and there are other
calculations I’m running that give me all the answers I’m looking for, but I
need the sections to be my key fields so I can match the data. Because this
one query I’m running leaves out the section name BISHOP, I cannot link my
queries together so I can put together a proper report.

My question is: “How do I get the section name to show up even if the
counted rank is a null value?†I understand that queries will not show a
null value for count, but I’m sure there is a way to make it happen?
 
Use queries with join lines that include all the records from one side of
the join. This would require a table of each unique rank.

--
Duane Hookom
MS Access MVP


"View Fields if Value is Null"
 
I thought I had found the answer here but no quite. See if you can help me
with my null problem.

I have 5 advisors, say Bob, Carol, Ted, Alice, and Toto.
I have clients that are LI/FG, LI, FG, and other.
"low income, first generation"
I want to run a query that counts each advisors number of each client
classification.
I want a total for all 5 advisors and if they have no "Other" clients, I
want the query to show zero for "Other". Right now, when I run the counting
query, if an advisor has no clients that are in one of the classifications,
then nothing is shown. Can you help me with this as this is probably an easy
one for you brainy guys.
 
Do you have a table of all possible unique values of LI/FG, LI, FG,...?
Do you have a table of all possible unique values of advisors?
What is your current SQL view that doesn't work?
 
Back
Top