Only want to include a field in the record under certain circumsta

[xX Longshank Xx]

I am designing a response log database for the fire departmetn I am working
for. I am trying to produce a report and querry in which an "address" field
is displayed based on the "Calltype" field. With HIPPA regulations, an
address cannot be displayed on locations for medical calls to the public but
I must display it for others. Any suggestions?

 

[John W. Vinson]

I am designing a response log database for the fire departmetn I am working
for. I am trying to produce a report and querry in which an "address" field
is displayed based on the "Calltype" field. With HIPPA regulations, an
address cannot be displayed on locations for medical calls to the public but
I must display it for others. Any suggestions?

Try using a calculated field such as

IIf([calltype] = "Medical", Null, [address])

in your query.

John W. Vinson [MVP]

 

[Marshall Barton]

I am designing a response log database for the fire departmetn I am working
for. I am trying to produce a report and querry in which an "address" field
is displayed based on the "Calltype" field. With HIPPA regulations, an
address cannot be displayed on locations for medical calls to the public but
I must display it for others.

Use a calculated field something like:

Addr: IIf(CallType=xxx, Null, Address)