How to

[fester]

I currently need to set up a report that shows me a listing of peoples email
addresses.
What i need is to set it up so that i only have a list showing:

Surname First Name Email Address

At this point in time the report I have created shows peoples names that do
not have an email address as well.
All i want to see is the names that have an email address and the address.
If any one knows how to set this up could you let me know from scratch and
in the siplest way. If relationships are involved could you please let me
know exactly how this would be done

Thanks

Fester

 

[fredg]

I currently need to set up a report that shows me a listing of peoples email
addresses.
What i need is to set it up so that i only have a list showing:

Surname First Name Email Address

At this point in time the report I have created shows peoples names that do
not have an email address as well.
All i want to see is the names that have an email address and the address.
If any one knows how to set this up could you let me know from scratch and
in the siplest way. If relationships are involved could you please let me
know exactly how this would be done

Thanks

Fester

One way is to create a new query.
Include those 3 fields.
As criteria on the Email address column, write:
Is Not Null

Use this query as the record source for your report.

Alternatively, you can open the existing report via a command button
click event, using:

DoCmd.OpenReport "ReportName", acViewPreview, , "[EmailField] Is Not
Null"

 

[fester]

Fred,

Sorry i gave a little less info than required. My fields run like so:

Surname First Name Email Surname2 First Name2 Email1

The issue i have is that not all the names in my database have an email
address. How can i do it so that it only shows those with an email address.

Thanks
Fester

I currently need to set up a report that shows me a listing of peoples email
addresses.
What i need is to set it up so that i only have a list showing:

Surname First Name Email Address

At this point in time the report I have created shows peoples names that do
not have an email address as well.
All i want to see is the names that have an email address and the address.
If any one knows how to set this up could you let me know from scratch and
in the siplest way. If relationships are involved could you please let me
know exactly how this would be done

Thanks

Fester

One way is to create a new query.
Include those 3 fields.
As criteria on the Email address column, write:
Is Not Null

Use this query as the record source for your report.

Alternatively, you can open the existing report via a command button
click event, using:

DoCmd.OpenReport "ReportName", acViewPreview, , "[EmailField] Is Not
Null"

 

[Damian S]

Are you using a table that has Surname, Firstname and Email as fields?

If so, you just need to use a query similar to the following:

Select surname, firstname, email from TABLE where email is not null;

Damian.

Fred,

Sorry i gave a little less info than required. My fields run like so:

Surname First Name Email Surname2 First Name2 Email1

The issue i have is that not all the names in my database have an email
address. How can i do it so that it only shows those with an email address.

Thanks
Fester

I currently need to set up a report that shows me a listing of peoples email
addresses.
What i need is to set it up so that i only have a list showing:

Surname First Name Email Address

At this point in time the report I have created shows peoples names that do
not have an email address as well.
All i want to see is the names that have an email address and the address.
If any one knows how to set this up could you let me know from scratch and
in the siplest way. If relationships are involved could you please let me
know exactly how this would be done

Thanks

Fester

One way is to create a new query.
Include those 3 fields.
As criteria on the Email address column, write:
Is Not Null

Use this query as the record source for your report.

Alternatively, you can open the existing report via a command button
click event, using:

DoCmd.OpenReport "ReportName", acViewPreview, , "[EmailField] Is Not
Null"

 

[fredg]

Fred,

Sorry i gave a little less info than required. My fields run like so:

Surname First Name Email Surname2 First Name2 Email1

The issue i have is that not all the names in my database have an email
address. How can i do it so that it only shows those with an email address.

Thanks
Fester

I currently need to set up a report that shows me a listing of peoples email
addresses.
What i need is to set it up so that i only have a list showing:

Surname First Name Email Address

At this point in time the report I have created shows peoples names that do
not have an email address as well.
All i want to see is the names that have an email address and the address.
If any one knows how to set this up could you let me know from scratch and
in the siplest way. If relationships are involved could you please let me
know exactly how this would be done

Thanks

Fester

One way is to create a new query.
Include those 3 fields.
As criteria on the Email address column, write:
Is Not Null

Use this query as the record source for your report.

Alternatively, you can open the existing report via a command button
click event, using:

DoCmd.OpenReport "ReportName", acViewPreview, , "[EmailField] Is Not
Null"

I'm still not sure what you want.
You have 2 email fields, and [Email1], correct?
And you want to exclude anyone who does not have an email address in
at least one of those fields.

One way is to create a new query.
Include those fields.

On the first criteria line for the Email column, write:
Is Not Null

On the first criteria line for the Email1 column, write
Is Not Null

Use this query as the record source for your report.

If the record contains an address in either the email or email1 field
it will be included in the query. If there is no address in both of
the fields, that record will not be in the report.