access reports based on a query

[TM2]

Hi,<br>I am creating a report based on information on a table named items.&nbsp;&nbsp;The table has two attributes for the value of an item.&nbsp;&nbsp;In the report I would like to show one attribute if the other attribute is null, can I do this??&nbsp;&nbsp;I don't want both to show up on the report.<br>Thanks,<br>Terri

 

[jimmythegeek]

Yes, create a query based on your table.<br>Put the following in the &quot;Field&quot; Row in a new column:<br><br>Attribute: IIf(IsNull([<font color=red>Attribute1]</font>),[<font color=blue>Attribute2</font>],[<font color=red>Attribute1</font>])<br><br>Save the query as whatever you want.<br>Create a report based on the query.<br>Now you can use the Attribute field, as a field on your report.<br><br>Obviously, you would include any other fields in your query besides the calculated Attribute field, and also change the names of the <font color=red>Attribute1</font> and <font color=blue>Attribute2</font> Fields to the appropriate fields. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development