Not show the data in the query

Hello,

I transfer the excel data to database, since I want bulit it's data base. I
found it that query will not show anything, if nothing filled in the other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.
--
H. Frank Situmorang

Use an outer join

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" wrote in message
...
Hello,

I transfer the excel data to database, since I want bulit it's data base.
I
found it that query will not show anything, if nothing filled in the other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering
anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next
member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.
--
H. Frank Situmorang

Allen, I have dobuble click the line, there is no option for OUTER Join, what
we have is

1. Only included rows when the joined filed from both tables are euqual
2. Included all records from "Jenis Kelamin". and only those records from
'Bukuangkby" when the joined fields are egual
3. Indclude all records from "Bukuangkby" and only those records from "Jenis
Kelamin" when the joined fields are equal

I do not know which one is outer joins.

We appreciate your help

Frank

--
H. Frank Situmorang


"Allen Browne" wrote:

Use an outer join

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" wrote in message
...
Hello,

I transfer the excel data to database, since I want bulit it's data base.
I
found it that query will not show anything, if nothing filled in the other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering
anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next
member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.
--
H. Frank Situmorang

The first one is the INNER join.

The other 2 are the outer joins (LEFT and RIGHT.)
Choose which table you want to return all records from.

Then, as the article points out, be careful about criteria you use on the
other table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" wrote in message
...
Allen, I have dobuble click the line, there is no option for OUTER Join,
what
we have is

1. Only included rows when the joined filed from both tables are euqual
2. Included all records from "Jenis Kelamin". and only those records from
'Bukuangkby" when the joined fields are egual
3. Indclude all records from "Bukuangkby" and only those records from
"Jenis
Kelamin" when the joined fields are equal

I do not know which one is outer joins.

We appreciate your help

Frank

--
H. Frank Situmorang


"Allen Browne" wrote:

Use an outer join

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

"Frank Situmorang" wrote in message
...
Hello,

I transfer the excel data to database, since I want bulit it's data
base.
I
found it that query will not show anything, if nothing filled in the
other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering
anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next
member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.
--
H. Frank Situmorang

Thank you Allen, it's clearer to me now, sorry for my stupid question maybe
since my specialist in fact is in finance and accounting but I try to do by
slef strudy since 30 yrs ago I took basic languange course, and I want to
refresh my mind now and it seems it works by the help of all good friends in
this forum.

Again, thank you very much.

--
H. Frank Situmorang


"Allen Browne" wrote:

The first one is the INNER join.

The other 2 are the outer joins (LEFT and RIGHT.)
Choose which table you want to return all records from.

Then, as the article points out, be careful about criteria you use on the
other table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" wrote in message
...
Allen, I have dobuble click the line, there is no option for OUTER Join,
what
we have is

1. Only included rows when the joined filed from both tables are euqual
2. Included all records from "Jenis Kelamin". and only those records from
'Bukuangkby" when the joined fields are egual
3. Indclude all records from "Bukuangkby" and only those records from
"Jenis
Kelamin" when the joined fields are equal

I do not know which one is outer joins.

We appreciate your help

Frank

--
H. Frank Situmorang


"Allen Browne" wrote:

Use an outer join

Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

"Frank Situmorang" wrote in message
...
Hello,

I transfer the excel data to database, since I want bulit it's data
base.
I
found it that query will not show anything, if nothing filled in the
other
table, like gender table.

My question is, is it the reason?.

in the linked field ( foreign key) is empty, can we proceed entering
anther
records. For example we have member table( member id) lingked to called
table, if there is no call for this member, I will proceed to the next
member
with the call data, can we proceed entering the data?

Thanks in advance for any idea provided.
--
H. Frank Situmorang