Fill in field based on criteria

[Jacques Latoison]

I have reports in Access that show personnel and their zip codes. I need to
have a report show an X in a field whenever someone's address matches a
certain zip code.

The real issue is that I need the report to ask for the zip codes because
its not static - EVER, and multiple data entry personnel generate the
reports based on given areas. They all access the same Access DB.

Thanks beforehand,

 

[Duane Hookom]

This question is a bit vague. Would a user enter a single zip when they open
the report? If so, you can add a checkbox to your report and set its control
source to:
=[PostalCodeField]=[Enter Zip Code]

 

[Jacques Latoison]

Actually they need to be able to enter any number of zip codes (up to ten I
believe)

This question is a bit vague. Would a user enter a single zip when they
open the report? If so, you can add a checkbox to your report and set its
control source to:
=[PostalCodeField]=[Enter Zip Code]

--
Duane Hookom
MS Access MVP

I have reports in Access that show personnel and their zip codes. I need
to have a report show an X in a field whenever someone's address matches a
certain zip code.

The real issue is that I need the report to ask for the zip codes because
its not static - EVER, and multiple data entry personnel generate the
reports based on given areas. They all access the same Access DB.

Thanks beforehand,

 

[Duane Hookom]

Then use:
=Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0

--
Duane Hookom
MS Access MVP
--

Actually they need to be able to enter any number of zip codes (up to ten
I believe)

This question is a bit vague. Would a user enter a single zip when they
open the report? If so, you can add a checkbox to your report and set its
control source to:
=[PostalCodeField]=[Enter Zip Code]

--
Duane Hookom
MS Access MVP

I have reports in Access that show personnel and their zip codes. I need
to have a report show an X in a field whenever someone's address matches
a certain zip code.

The real issue is that I need the report to ask for the zip codes
because its not static - EVER, and multiple data entry personnel
generate the reports based on given areas. They all access the same
Access DB.

Thanks beforehand,

 

[Jacques Latoison]

Duane,
I've been ill and busy, and just got around to trying it out. It seems
to work except it puts either a 0 or a -1. How do I get it to put an X or
nothing?

Thanks beforehand, and my apologies for not getting back sooner.

Then use:
=Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0

--
Duane Hookom
MS Access MVP
--

Actually they need to be able to enter any number of zip codes (up to ten
I believe)

This question is a bit vague. Would a user enter a single zip when they
open the report? If so, you can add a checkbox to your report and set
its control source to:
=[PostalCodeField]=[Enter Zip Code]

--
Duane Hookom
MS Access MVP


"Jacques Latoison" <Jacques Latoison at hotmail dot com> wrote in
message I have reports in Access that show personnel and their zip codes. I
need to have a report show an X in a field whenever someone's address
matches a certain zip code.

The real issue is that I need the report to ask for the zip codes
because its not static - EVER, and multiple data entry personnel
generate the reports based on given areas. They all access the same
Access DB.

Thanks beforehand,

 

[Duane Hookom]

=IIF( Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0 ,
"X","")



--
Duane Hookom
MS Access MVP
--

Duane,
I've been ill and busy, and just got around to trying it out. It seems
to work except it puts either a 0 or a -1. How do I get it to put an X or
nothing?

Thanks beforehand, and my apologies for not getting back sooner.

Then use:
=Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0

--
Duane Hookom
MS Access MVP
--

Actually they need to be able to enter any number of zip codes (up to
ten I believe)


This question is a bit vague. Would a user enter a single zip when they
open the report? If so, you can add a checkbox to your report and set
its control source to:
=[PostalCodeField]=[Enter Zip Code]

--
Duane Hookom
MS Access MVP


"Jacques Latoison" <Jacques Latoison at hotmail dot com> wrote in
message I have reports in Access that show personnel and their zip codes. I
need to have a report show an X in a field whenever someone's address
matches a certain zip code.

The real issue is that I need the report to ask for the zip codes
because its not static - EVER, and multiple data entry personnel
generate the reports based on given areas. They all access the same
Access DB.

Thanks beforehand,

 

[Jacques Latoison]

That worked out great Duane.

Thank you very much.

=IIF( Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0 ,
"X","")



--
Duane Hookom
MS Access MVP
--

Duane,
I've been ill and busy, and just got around to trying it out. It
seems to work except it puts either a 0 or a -1. How do I get it to put
an X or nothing?

Thanks beforehand, and my apologies for not getting back sooner.

Then use:
=Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0

--
Duane Hookom
MS Access MVP
--

"Jacques Latoison" <Jacques Latoison at hotmail dot com> wrote in
message Actually they need to be able to enter any number of zip codes (up to
ten I believe)


This question is a bit vague. Would a user enter a single zip when
they open the report? If so, you can add a checkbox to your report and
set its control source to:
=[PostalCodeField]=[Enter Zip Code]

--
Duane Hookom
MS Access MVP


"Jacques Latoison" <Jacques Latoison at hotmail dot com> wrote in
message I have reports in Access that show personnel and their zip codes. I
need to have a report show an X in a field whenever someone's address
matches a certain zip code.

The real issue is that I need the report to ask for the zip codes
because its not static - EVER, and multiple data entry personnel
generate the reports based on given areas. They all access the same
Access DB.

Thanks beforehand,