Missing Infor.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000
I created a Db for our Quotes. I also have a report that searches by
Salesperson
for the Quotes that need to be followed up by him/her. The salesman's name
appears in the page header. The data (quotes that need to be followed up) is
in the ID header. When there is data in the report, everything comes up
fine. The salesman's name appears in the page header.

But, if there is no data, the Salesman's name does not appear on the report
where it should. If there any way to make sure the Salesman's name appears
whether there is data or not?

thank you in advance - Aurora
 
In your query instead of the DataField use this --
Iif([DataField] Is Null, "No quote",[DataField])
 
Does the Salesman's name appear in the report's record source query? If not,
change the joins or whatever to assure that all salesmen are displayed.
 
Back
Top