Using selction criteria in report field

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

xX Longshank Xx

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
 
Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
 
Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


Klatuu said:
Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
 
No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


Klatuu said:
Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
I tried you correction and instead of displaying the address, it displays
#error and has a message that states "this control has a reference to
itself". I am placing the expression in the control source protperty of the
Address control. I tried placing hte expression in the Calltype control but
that did not work either.
--
E


Klatuu said:
No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


Klatuu said:
Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


:

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
It should be in the Address control.
The problem may be that the record source field name and the report control
name are the same. I know Access does this by default, but it can cause this
sort of problem. Try renaming the control to something like txtAddress. The
txt, using Reddick naming conventions means the name referres to a text box
control.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I tried you correction and instead of displaying the address, it displays
#error and has a message that states "this control has a reference to
itself". I am placing the expression in the control source protperty of the
Address control. I tried placing hte expression in the Calltype control but
that did not work either.
--
E


Klatuu said:
No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


:

Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


:

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
I tried renaming the control to txtAddress but the same #error is displayed
where addresses should be shown. I get the following message when I move the
cursor over the warning symple next to the expression box in design view
"Invalid control property: control source circular referrence. Thanks for
hanging in there with me.
--
E


Klatuu said:
It should be in the Address control.
The problem may be that the record source field name and the report control
name are the same. I know Access does this by default, but it can cause this
sort of problem. Try renaming the control to something like txtAddress. The
txt, using Reddick naming conventions means the name referres to a text box
control.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I tried you correction and instead of displaying the address, it displays
#error and has a message that states "this control has a reference to
itself". I am placing the expression in the control source protperty of the
Address control. I tried placing hte expression in the Calltype control but
that did not work either.
--
E


Klatuu said:
No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


:

Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


:

Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


:

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
I jsut noticed that when I edited the control source name it updated the
control source protoperty. I edited the property and it works like a champ.
Thanks for your help. Can I make a macro that would generate a weekly run
report automatically on Tuesdays?
--
E


Klatuu said:
It should be in the Address control.
The problem may be that the record source field name and the report control
name are the same. I know Access does this by default, but it can cause this
sort of problem. Try renaming the control to something like txtAddress. The
txt, using Reddick naming conventions means the name referres to a text box
control.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I tried you correction and instead of displaying the address, it displays
#error and has a message that states "this control has a reference to
itself". I am placing the expression in the control source protperty of the
Address control. I tried placing hte expression in the Calltype control but
that did not work either.
--
E


Klatuu said:
No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


:

Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


:

Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


:

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
I am stumped. That should work. I have never seen that error before.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I tried renaming the control to txtAddress but the same #error is displayed
where addresses should be shown. I get the following message when I move the
cursor over the warning symple next to the expression box in design view
"Invalid control property: control source circular referrence. Thanks for
hanging in there with me.
--
E


Klatuu said:
It should be in the Address control.
The problem may be that the record source field name and the report control
name are the same. I know Access does this by default, but it can cause this
sort of problem. Try renaming the control to something like txtAddress. The
txt, using Reddick naming conventions means the name referres to a text box
control.
--
Dave Hargis, Microsoft Access MVP


xX Longshank Xx said:
I tried you correction and instead of displaying the address, it displays
#error and has a message that states "this control has a reference to
itself". I am placing the expression in the control source protperty of the
Address control. I tried placing hte expression in the Calltype control but
that did not work either.
--
E


:

No, I wrote it wrong, sorry. It should be:
=IIf([CallType] = "Medical", "", [Address])

It means If the CallType Field in the reports record source is equal to
Medical, then nothing will display. If it is not medical, the address will
display.

I used the word "Medical" per your examle. Use whatever the value in
CallType would be to indicate medical.

--
Dave Hargis, Microsoft Access MVP


:

Thanks for the response. I tried using the below control source and it
removed the address from the medical but instead of leaving addresses on the
other call types, it repeated the call type. I tried to replace the ending
control with address and a #error message was displayed where the address
should be. To further my understanding of this. Does the expression you
sent me mean: if f the calltype equals medical then display calltype?

Thanks again and would appreciate any additional help
--
E


:

Use this as the control source for the Address control:

=IIf([CallType] = "Medical", "", [CallType])

Note, use the record source field name, not the report control names.
--
Dave Hargis, Microsoft Access MVP


:

I am currently working on a response log data base for the fire district. In
the log I have fields such as RunNumber, Calltype, Date, Address, and others.
I need to build a press report from the response log table that includes the
above fields. To stay compliant with HIPPA regulations, I can not have the
adress field be shown when the Calltype is medical. I have tried mutiple
expressions and have not accomplished not displaying the address field whe
the Calltype field is medical. Any suggestions would be most welcome and
appreciated
Click to expand...
Click to expand...
Click to expand...
 
Back
Top