adding field to report

[Perplexed]

I have a report which lists customers of the the entire database who have
cancelled their appointments showing the date and reason. When I try to add
a field from a third table that gives the date that the customer was
contacted about their cancellation, the report reduces from 12 pages to 2
because it is not only showing customers with cancelled appointments who have
been contacted. I want the report to reflect all customers who have
cancelled appointments and show which ones have been contacted and which ones
have not by having the date contacted field displayed regardless of whether
there is an entry or not. HELP!
Thanks. . .

 

[Marshall Barton]

I have a report which lists customers of the the entire database who have
cancelled their appointments showing the date and reason. When I try to add
a field from a third table that gives the date that the customer was
contacted about their cancellation, the report reduces from 12 pages to 2
because it is not only showing customers with cancelled appointments who have
been contacted. I want the report to reflect all customers who have
cancelled appointments and show which ones have been contacted and which ones
have not by having the date contacted field displayed regardless of whether
there is an entry or not. HELP!

In the report's record source query, use an outer join
instead of an inner join.

If that's not enough info to get you going, then please
provide us with more info to help us understand the problem.
Especially important is a Copy/Paste of the record source
query's SQL View.

 

[Perplexed]

Thanks for your advice; however, I figured it out. My table "relationships"
weren't quite right -- in that I didn't have a record with a contact date for
every customer record. Therefore it was only printing those that did. I
went back to my input form and made a "null" entry for every record for
customers that hadn't been contacted and now my report works. The next
challenge will be for me to figure out how to create a record with an
automatic null entry in the date field each time a new customer is added to
the database. Hope you have some advice for this!

Thanks again!

 

[Marshall Barton]

Same advice as before. Using an outer join will supply Null
values for any missing contacts. Doing this will eliminate
the need to create (automatically or otherwise) records with
Null values. Post the SQL view of the report's record
source query and we'll see what we can do.