criteria for showing (or not showing) data in a query field.

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Hi

I have a report based on a query. I want one field to be displayed on the
report only when data are displayed in another field.

What I want to do is show a "cc:" on my report only when there is a value in
another field displaying [Title]&" "&[FirstName]&" "&[LastName]. However, I
also want to be able to display those records with no "cc:"

Any suggestions. I have tried various criteria in the query design window,
but have not been able to produce the desired results.

Thanks in advance
Anthony
 
I found a solution to this problem myself. It was simply a matter of
including another field in the underlying table (ie the table upon which the
query is based) with a default value of "cc:". This field does not appear on
the form.

I then included this field and another (ie with a calculated field with the
control source: [TableName.Title]&" "&[TableName.FirstName]&"
"&[TableName.LastName].

This combined "cc" and "full name" field then returns a value only when the
user selects a name from the combo box in the form.

So far, so good!
 
Back
Top