Not show the data in the query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Situmorang - 28 Dec 2007 08:37 GMT

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.

Signature

H. Frank Situmorang

Reply to this Message

Allen Browne - 28 Dec 2007 09:16 GMT

Use an outer join

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

Signature

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.

> Hello,
>
[quoted text clipped - 13 lines]
>
> Thanks in advance for any idea provided.

Reply to this Message

Frank Situmorang - 28 Dec 2007 10:28 GMT

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

Signature

H. Frank Situmorang

> Use an outer join
>
[quoted text clipped - 20 lines]
> >
> > Thanks in advance for any idea provided.

Reply to this Message

Allen Browne - 28 Dec 2007 13:26 GMT

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.

Signature

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.

> Allen, I have dobuble click the line, there is no option for OUTER Join,
> what
[quoted text clipped - 39 lines]
>> >
>> > Thanks in advance for any idea provided.

Reply to this Message

Frank Situmorang - 30 Dec 2007 02:37 GMT

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.

Signature

H. Frank Situmorang

> The first one is the INNER join.
>
[quoted text clipped - 47 lines]
> >> >
> >> > Thanks in advance for any idea provided.

Reply to this Message