Please, Help (Urgent)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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).
.

Relevant Pages

  • Re: Please, Help (Urgent)
    ... Sent' and only those records from 'Correspondence Received' where the joined ... I'm having problems creating a report. ... Our Reference Number ... The problem is that the report only shows the faxes that have gotten ...
    (microsoft.public.access.reports)
  • RE: Please, Help (Urgent)
    ... I'm having problems creating a report. ... I have created a DB to handle our company's correspondence. ... Our Reference Number ... The problem is that the report only shows the faxes that have gotten ...
    (microsoft.public.access.reports)
  • Re: Please, Help (Urgent)
    ... Sent' and only those records from 'Correspondence Received' where the joined ... Igor wrote: ... I'm having problems creating a report. ... Our Reference Number ...
    (microsoft.public.access.reports)
  • Re: counting blank cells
    ... You could try going the other way and copy the "Deliquency report" to the "04mqu". ... Please keep all correspondence within the NewsGroup, ... I copied a sheet from another workbook. ...
    (microsoft.public.excel.misc)
  • Re: Excel Spreadsheet
    ... Check out this web page of David McRitchie: ... Please keep all correspondence within the NewsGroup, ... report. ...
    (microsoft.public.excel.misc)