Please, Help (Urgent)

[Igor]

Hello, everyone,

I'm having problems creating a report. Could someone please give me a hand?

I have created a DB to handle our company's correspondence.

But I have been unable to create a report that generates all the relevant
information. The fields relevant for the report are:

Fax (yes/no type)
File (text type)
Title (text type)
Document Number (text type)
Revision (text type)
Date Sent (date/time type)
Our Reference Number (text type)
Reply Received (yes/no type)
3P Reference Number (text type)
Date Received (date/time type)

On the table Correspondence Sent I have the first 8 fields. And on the table
Correspondence Received I have the last field (Reply Received On). The two
tables are linked by the field 3P Reference Number. Through this link I get
the date we received the reply (Date Received).

I need to show all the information for a specific Correspondence Type (=
Faxes). The problem is that the report only shows the faxes that have gotten
a reply. On the DB if there's no reply the value for the field 3P Reference
Number is blank.

Does anyone know what I'm doing wrong?

I would appreciate all the help that I could get because I need to have this
ready as soon as possible (you know how bosses are).

 

[Golfinray]

I am not quite understanding. If you have no Correspondence Type (=

 

[Igor]

Hello!

Thank you for taking the time to help me.

The report has to show all requested fields for Correspondence Type ( =
Faxes). The field Correspondence Type will always have a value since it is a
yes/no data type.

The field which will not always have a value is 3P Reference Number. Wether
or not it has a value depends on wether or not we have received a reply to
the fax.

The report, as I have it now, only shows me the requested information for
the faxes
that have a reply. All faxes that do not have a reply are not shown in the
report, are omitted. >>> But I need the report to show the information (i.e.
the requested fields) for all faxes, regardless of wether or not we have
received a reply.

I hope it's clearer now. And thanks again for your help.

 

[Igor]

One more thing:

The field 3P reference Number is the reference number of the reply we got to
the Fax we sent.

I hope this helps a little bit more.

Thanks again!

 

[tcsteele via AccessMonster.com]

In the query you have which link the two tables, make sure that you select
the "Join Properties" that says "Include ALL Records from 'Correspondence
Sent' and only those records from 'Correspondence Received' where the joined
fields are equal.

 

[Igor]

I can't believe that the answer was so simple!!!

Thank you sooooooooooo much!!!!!

I greatly appreciate your help.