Adjust Title based on query values

  • Thread starter Thread starter AL
  • Start date Start date
A

AL

Values in a particular field in a dataset include the
numbers 1,2,3,4. Sometimes all the numbers appear but
sometimes only 2 of the numbers appear. I'd like to
adjust my report title to reflect only the numbers which
appear. How might I go about solving this?
 
Without knowing more details, you could try to create a
querry summing for that data field with each of the
numbers like:
PartName4:IIf([YourFieldName] Like "*4*",1,0)
You can do this for each of the numbers you wish to scan
for.
Than in your report you can include in the title the
PartName1,2,3 and 4
With a variety of IIF statement you can make this look
like you want.
Hope this helps.
Fons
 
Back
Top