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!

 

[Igor]

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

Thank you sooooooooooo much!!!!!

I greatly appreciate your help.