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

  • Thread starter Thread starter xX Longshank Xx
  • Start date Start date
X

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?
 
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?
Click to expand...

Try using a calculated field such as

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

in your query.

John W. Vinson [MVP]
 
xX said:
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.
Click to expand...


Use a calculated field something like:

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