See Null or Zero Fields on a Query

U

Utopian

Hello to all!

The reason for this consultation is to see if they can help me with the
following thing:

1-I have a few tables imported from SQL to the Access, with which it makes
the scheme of RELATIONS in Access and it assigns the major keys to him....
At the time of making a consultation where it shows "ALL the REGISTRIES to
me" it shows to me 150 less of the total than he is 3000... investigating as
they lacked, I occurred to account of that are those that has any field "IN
TARGET"... My question is: Since I do so that it shows all the registries
to me, including which they do not have all the fields with data?

2 -Another related question is: So that having already made the relations
in "Tools > > Relations", soon when doing the consultation in view of
design, I incorporate the tables and bring to me BADLY all RELATED and not
since I did in the diagram of Relations.....? in this case which I did it
was to erase them and to remake them in the consultation. It is that normal
one? Thank you very much beforehand! Adrian

Sorry for my english!!!!!!!!!!

Thanks a lot!!

Utopian
 
R

rowiga

Hi Utopian,

1) I believe that you want to look into using the Nz function (NullZero) in
Access:

Nz(variant[, valueifnull])

which means....Nz(YourFieldName,FieldValue IfNull)

2) I don't believe that you're going to get any kind of automatic
relationships when importing another table into Access.
 
U

Utopian

Hello!
Thanks for the answer

Where I must place this function?
How it is implemented?

Thank you very much

Utopian.-

--------------------------------------------------------------------------------

rowiga said:
Hi Utopian,

1) I believe that you want to look into using the Nz function (NullZero) in
Access:

Nz(variant[, valueifnull])

which means....Nz(YourFieldName,FieldValue IfNull)

2) I don't believe that you're going to get any kind of automatic
relationships when importing another table into Access.

Utopian said:
Hello to all!

The reason for this consultation is to see if they can help me with the
following thing:

1-I have a few tables imported from SQL to the Access, with which it makes
the scheme of RELATIONS in Access and it assigns the major keys to him....
At the time of making a consultation where it shows "ALL the REGISTRIES to
me" it shows to me 150 less of the total than he is 3000... investigating as
they lacked, I occurred to account of that are those that has any field "IN
TARGET"... My question is: Since I do so that it shows all the registries
to me, including which they do not have all the fields with data?

2 -Another related question is: So that having already made the relations
in "Tools > > Relations", soon when doing the consultation in view of
design, I incorporate the tables and bring to me BADLY all RELATED and not
since I did in the diagram of Relations.....? in this case which I did it
was to erase them and to remake them in the consultation. It is that normal
one? Thank you very much beforehand! Adrian

Sorry for my english!!!!!!!!!!

Thanks a lot!!

Utopian
Click to expand...
Click to expand...
 
Top