report or query help

J

Jen

I am trying to get a report or query of some kind but not
sure how to do it. I have about 2000 entries in my table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three and
some gave all of the information. Is there anyway to
shift the contact information over for someone without a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
 
F

Fons Ponsioen

Hi.
The best way to do that is to concatanate the data wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
 
G

Guest

Thanks...I understand what you are saying and I tried it
but I don't know what to put for field names. The ones I
don't have in down in the field column I get asked at the
beginning of the query to type in what zip i want it for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address, city
and so on in the next?

Thanks,
Jen
-----Original Message-----
Hi.
The best way to do that is to concatanate the data wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but not
sure how to do it. I have about 2000 entries in my table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three and
some gave all of the information. Is there anyway to
shift the contact information over for someone without a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.
Click to expand...
.
Click to expand...
 
F

Fons Ponsioen

Hi Jen.
First let me ask you, Are you concatenating in the report
or are you doing it in a query.
If you are doing it in query, you would put in the Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried it
but I don't know what to put for field names. The ones I
don't have in down in the field column I get asked at the
beginning of the query to type in what zip i want it for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address, city
and so on in the next?

Thanks,
Jen
-----Original Message-----
Hi.
The best way to do that is to concatanate the data wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but not
sure how to do it. I have about 2000 entries in my table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three and
some gave all of the information. Is there anyway to
shift the contact information over for someone without a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
G

Guest

Thanks so much for your help...everything is working now
the way I was wanting it except now the people with only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen
-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the report
or are you doing it in a query.
If you are doing it in query, you would put in the Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried it
but I don't know what to put for field names. The ones I
don't have in down in the field column I get asked at the
beginning of the query to type in what zip i want it for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address, city
and so on in the next?

Thanks,
Jen
-----Original Message-----
Hi.
The best way to do that is to concatanate the data wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but not
sure how to do it. I have about 2000 entries in my table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three and
some gave all of the information. Is there anyway to
shift the contact information over for someone
Click to expand...
without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
F

Fons Ponsioen

Jen. Can you post a copy of the actual formula you are
using for the combined address so I can review if there is
an error.
Thanks.
Fons
-----Original Message-----
Thanks so much for your help...everything is working now
the way I was wanting it except now the people with only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen
-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the report
or are you doing it in a query.
If you are doing it in query, you would put in the Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried it
but I don't know what to put for field names. The ones I
don't have in down in the field column I get asked at the
beginning of the query to type in what zip i want it for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address, city
and so on in the next?

Thanks,
Jen

-----Original Message-----
Hi.
The best way to do that is to concatanate the data
wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is
null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but
not
sure how to do it. I have about 2000 entries in my
table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of
my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three
and
some gave all of the information. Is there anyway to
shift the contact information over for someone without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
G

Guest

Thank you...here is the info.


Field Name: Name] & " " & [Last Name]

Criteria: [First Name] & " " & [Last Name]

Field Name: Contact: [Address] & " " & [City] & " " &
[State] & " " & [Zip Code] & " " & [Phone Number] & " " &
[Email Address]

Criteria: [Address] & IIf([City] Is Null," "," " &
[City]) & IIf([State] Is Null,""," " & [State]) & IIf
([Zip Code] Is Null,""," " & [Zip Code]) & IIf([Phone
Number] Is Null,""," " & [Phone Number]) & IIf([Email
Address] Is Null,""," " & [Email Address])




-----Original Message-----
Jen. Can you post a copy of the actual formula you are
using for the combined address so I can review if there is
an error.
Thanks.
Fons
-----Original Message-----
Thanks so much for your help...everything is working now
the way I was wanting it except now the people with only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen
-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the report
or are you doing it in a query.
If you are doing it in query, you would put in the Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif ([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried it
but I don't know what to put for field names. The
Click to expand...
ones
I
don't have in down in the field column I get asked at the
beginning of the query to type in what zip i want it for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address, city
and so on in the next?

Thanks,
Jen

-----Original Message-----
Hi.
The best way to do that is to concatanate the data
wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is
null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but
not
sure how to do it. I have about 2000 entries in my
table
and have column titles address, city, state, zip code,
phone number and email address among others. Some of
my
entries only gave an address or only a phone number or
only an email address, some gave two of the the three
and
some gave all of the information. Is there anyway to
shift the contact information over for someone without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
F

Fons Ponsioen

Okay, if you are using a query we are only interested in
the "field:" box, in the field box you would enter:
YourFieldName:Your formula
which is,
FullName:[First Name] & " " & [Last Name]
and for what I'll refer to as the combined address line
the same format:
YourFieldName:Your formula
which is,
Contact: IIF([Address] is null,"",[Address]) & IIf([City]
Is Null," "," " & [City]) & IIf([State] Is Null,""," " &
[State]) & IIf([Zip Code] Is Null,""," " & [Zip Code]) &
IIf([Phone Number] Is Null,""," " & [Phone Number]) & IIf
([Email Address] Is Null,""," " & [Email Address])
Make sure all names of the variables are just as you have
them in your table.
The field names as above "FullName" and "Contact" would be
used in the report (without the '"' quotes.
Now if you are just using the table as the source for your
report you would use just the formula portion starting
with the "=" in the applicable text boxes of your report.

Note: You indicated that there are spaces in the variable
names. I would recommend that you avoid using spaces,
that will make your database more reliable.
Hope this helps
P.S. if you wish you may contact me at:
F O N S P O N S I O @ M S N . C O M
That way I don't have to go look this line since it is
getting further down the pages.
Take care.
Fons

-----Original Message-----
Thank you...here is the info.


Field Name: Name] & " " & [Last Name]

Criteria: [First Name] & " " & [Last Name]

Field Name: Contact: [Address] & " " & [City] & " " &
[State] & " " & [Zip Code] & " " & [Phone Number] & " " &
[Email Address]

Criteria: [Address] & IIf([City] Is Null," "," " &
[City]) & IIf([State] Is Null,""," " & [State]) & IIf
([Zip Code] Is Null,""," " & [Zip Code]) & IIf([Phone
Number] Is Null,""," " & [Phone Number]) & IIf([Email
Address] Is Null,""," " & [Email Address])




-----Original Message-----
Jen. Can you post a copy of the actual formula you are
using for the combined address so I can review if there is
an error.
Thanks.
Fons
-----Original Message-----
Thanks so much for your help...everything is working now
the way I was wanting it except now the people with only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen

-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the
report
or are you doing it in a query.
If you are doing it in query, you would put in the
Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif ([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I
used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried
it
but I don't know what to put for field names. The ones
I
don't have in down in the field column I get asked at
the
beginning of the query to type in what zip i want it
for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address,
city
and so on in the next?

Thanks,
Jen

-----Original Message-----
Hi.
The best way to do that is to concatanate the data
wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is
null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but
not
sure how to do it. I have about 2000 entries in my
table
and have column titles address, city, state, zip
code,
phone number and email address among others. Some of
my
entries only gave an address or only a phone number
or
only an email address, some gave two of the the three
and
some gave all of the information. Is there anyway to
shift the contact information over for someone
without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
J

Jen

Thanks it worked!!!!


-----Original Message-----
Okay, if you are using a query we are only interested in
the "field:" box, in the field box you would enter:
YourFieldName:Your formula
which is,
FullName:[First Name] & " " & [Last Name]
and for what I'll refer to as the combined address line
the same format:
YourFieldName:Your formula
which is,
Contact: IIF([Address] is null,"",[Address]) & IIf ([City]
Is Null," "," " & [City]) & IIf([State] Is Null,""," " &
[State]) & IIf([Zip Code] Is Null,""," " & [Zip Code]) &
IIf([Phone Number] Is Null,""," " & [Phone Number]) & IIf
([Email Address] Is Null,""," " & [Email Address])
Make sure all names of the variables are just as you have
them in your table.
The field names as above "FullName" and "Contact" would be
used in the report (without the '"' quotes.
Now if you are just using the table as the source for your
report you would use just the formula portion starting
with the "=" in the applicable text boxes of your report.

Note: You indicated that there are spaces in the variable
names. I would recommend that you avoid using spaces,
that will make your database more reliable.
Hope this helps
P.S. if you wish you may contact me at:
F O N S P O N S I O @ M S N . C O M
That way I don't have to go look this line since it is
getting further down the pages.
Take care.
Fons

-----Original Message-----
Thank you...here is the info.


Field Name: Name] & " " & [Last Name]

Criteria: [First Name] & " " & [Last Name]

Field Name: Contact: [Address] & " " & [City] & " " &
[State] & " " & [Zip Code] & " " & [Phone Number] & " " &
[Email Address]

Criteria: [Address] & IIf([City] Is Null," "," " &
[City]) & IIf([State] Is Null,""," " & [State]) & IIf
([Zip Code] Is Null,""," " & [Zip Code]) & IIf([Phone
Number] Is Null,""," " & [Phone Number]) & IIf([Email
Address] Is Null,""," " & [Email Address])




-----Original Message-----
Jen. Can you post a copy of the actual formula you are
using for the combined address so I can review if
Click to expand...
there
is
an error.
Thanks.
Fons
-----Original Message-----
Thanks so much for your help...everything is working now
the way I was wanting it except now the people with only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen

-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the
report
or are you doing it in a query.
If you are doing it in query, you would put in the
Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif ([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I
used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried
it
but I don't know what to put for field names. The ones
I
don't have in down in the field column I get asked at
the
beginning of the query to type in what zip i want it
for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address,
city
and so on in the next?

Thanks,
Jen

-----Original Message-----
Hi.
The best way to do that is to concatanate the data
wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is
null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind but
not
sure how to do it. I have about 2000 entries in my
table
and have column titles address, city, state, zip
code,
phone number and email address among others.
Click to expand...
Some
of
my
entries only gave an address or only a phone number
or
only an email address, some gave two of the the three
and
some gave all of the information. Is there
Click to expand...
anyway
to
shift the contact information over for someone
without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.
Click to expand...
Click to expand...
Click to expand...
 
F

Fons Ponsioen

You're welcome.
-----Original Message-----
Thanks it worked!!!!


-----Original Message-----
Okay, if you are using a query we are only interested in
the "field:" box, in the field box you would enter:
YourFieldName:Your formula
which is,
FullName:[First Name] & " " & [Last Name]
and for what I'll refer to as the combined address line
the same format:
YourFieldName:Your formula
which is,
Contact: IIF([Address] is null,"",[Address]) & IIf ([City]
Is Null," "," " & [City]) & IIf([State] Is Null,""," " &
[State]) & IIf([Zip Code] Is Null,""," " & [Zip Code]) &
IIf([Phone Number] Is Null,""," " & [Phone Number]) & IIf
([Email Address] Is Null,""," " & [Email Address])
Make sure all names of the variables are just as you have
them in your table.
The field names as above "FullName" and "Contact" would be
used in the report (without the '"' quotes.
Now if you are just using the table as the source for your
report you would use just the formula portion starting
with the "=" in the applicable text boxes of your report.

Note: You indicated that there are spaces in the variable
names. I would recommend that you avoid using spaces,
that will make your database more reliable.
Hope this helps
P.S. if you wish you may contact me at:
F O N S P O N S I O @ M S N . C O M
That way I don't have to go look this line since it is
getting further down the pages.
Take care.
Fons

-----Original Message-----
Thank you...here is the info.


Field Name: Name] & " " & [Last Name]

Criteria: [First Name] & " " & [Last Name]

Field Name: Contact: [Address] & " " & [City] & " " &
[State] & " " & [Zip Code] & " " & [Phone Number] & " " &
[Email Address]

Criteria: [Address] & IIf([City] Is Null," "," " &
[City]) & IIf([State] Is Null,""," " & [State]) & IIf
([Zip Code] Is Null,""," " & [Zip Code]) & IIf([Phone
Number] Is Null,""," " & [Phone Number]) & IIf([Email
Address] Is Null,""," " & [Email Address])





-----Original Message-----
Jen. Can you post a copy of the actual formula you are
using for the combined address so I can review if there
is
an error.
Thanks.
Fons
-----Original Message-----
Thanks so much for your help...everything is working
now
the way I was wanting it except now the people with
only
phone numbers and emails aren't showing up...it's only
ones that have at least an address.

Thanks,
Jen

-----Original Message-----
Hi Jen.
First let me ask you, Are you concatenating in the
report
or are you doing it in a query.
If you are doing it in query, you would put in the
Field:
for the Name data field:
CombinedName=[LastName] & " " & [FirstName]
than for the (I'll call it) address field:
CombinedAddress=[Address] & iif([City] is null,""," " &
[City])& iif([State] is null,""," " &[State])& iif
([ZipCode] is null,""," " &[ZipCode])& iif
([PhoneNumber]
is null,""," " &[PhoneNumber])& iif([EmailAddress] is
null,""," " &[EmailAddress])
Now on your reportyou would place two text boxes one
for
the CombinedName and one for the CombinedAddress.
You will ofcourse have to make sure that the names I
used
are what you realy have in your table and for
the "CombinedName" and "CombinedAddress" you may
substittue any name you wish to use as long as it is
not
one you allready used in table or any restricted name.
Hope this clears things up
If you use not a query but a table as the source of
your
report, you can substitute the two variable strings
starting with the "=" in the textboxes on the report.
Hope this cleared it up a bit.
Fons
-----Original Message-----
Thanks...I understand what you are saying and I tried
it
but I don't know what to put for field names. The
ones
I
don't have in down in the field column I get asked at
the
beginning of the query to type in what zip i want it
for
and so on. How can i get it to recognize i want both
first and last name in one field....and the address,
city
and so on in the next?

Thanks,
Jen

-----Original Message-----
Hi.
The best way to do that is to concatanate the data
wanted,
for instance:
The first text box in your report or query would be:
=[LastName] & " " & [FirstName]
than the second textbox would be:
=[Address] & iif([City] is null,""," " &[City])& iif
([State] is null,""," " &[State])& iif([ZipCode] is
null,""," " &[ZipCode])& iif([PhoneNumber] is
null,""," " &
[PhoneNumber])& iif([EmailAddress] is null,""," " &
[EmailAddress])
Doing it this way would prevent unnecessary spaces
etc.
Hope this helps
Fons
-----Original Message-----
I am trying to get a report or query of some kind
but
not
sure how to do it. I have about 2000 entries in my
table
and have column titles address, city, state, zip
code,
phone number and email address among others. Some
of
my
entries only gave an address or only a phone number
or
only an email address, some gave two of the the
three
and
some gave all of the information. Is there anyway
to
shift the contact information over for someone
without
a
given address? If anyone can help, thanks a bunch!

Jen

Example:

Doe Jon 1 N Main Monmouth IL 61462 [email protected]

Fox Lisa 309-734-5555 [email protected]
.
Click to expand...
Click to expand...

.
Click to expand...
 
Top