Fill in field based on criteria

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

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,
 
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]
 
Actually they need to be able to enter any number of zip codes (up to ten I
believe)


Duane Hookom said:
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 said:
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,
Click to expand...
Click to expand...
 
Then use:
=Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0

--
Duane Hookom
MS Access MVP
--

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


Duane Hookom said:
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 said:
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,
Click to expand...
Click to expand...
Click to expand...
 
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.


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

--
Duane Hookom
MS Access MVP
--

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


Duane Hookom said:
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,
Click to expand...
Click to expand...
Click to expand...
 
=IIF( Instr([Enter Zip Codes with spaces between], [PostalCodeField])>0 ,
"X","")



--
Duane Hookom
MS Access MVP
--

Jacques Latoison said:
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.


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

--
Duane Hookom
MS Access MVP
--

Jacques Latoison said:
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,
Click to expand...
Click to expand...
Click to expand...
 
That worked out great Duane.

Thank you very much.


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



--
Duane Hookom
MS Access MVP
--

Jacques Latoison said:
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.


Duane Hookom said:
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,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top