Printing information that start with a particular letter

[Guest]

I have a database of names and addresses. one of the things that I want to do
is to print all the records that match a letter of the alphabet. I want to be
able to tell a report to print all the A's and on another day print all of
the S's for example

 

[Guest]

On the form from which you call the report, In the criteria of the query upon
which the report is based have a text box (e.g. AlphaFilter) where the user
can type in a wildcard filter (e.g. s*). Then, use the Like operator in your
query (Like [Forms]![Form1]![AlphaFilter] to show only those records that are
like the string. You could even have the user just enter the first letter and
build the Like statement using the letter and adding the wildcard.

 

[Guest]

Brian

Thankyou for your reply. I think I understand> I will give it a go.

On the form from which you call the report, In the criteria of the query upon
which the report is based have a text box (e.g. AlphaFilter) where the user
can type in a wildcard filter (e.g. s*). Then, use the Like operator in your
query (Like [Forms]![Form1]![AlphaFilter] to show only those records that are
like the string. You could even have the user just enter the first letter and
build the Like statement using the letter and adding the wildcard.

I have a database of names and addresses. one of the things that I want to do
is to print all the records that match a letter of the alphabet. I want to be
able to tell a report to print all the A's and on another day print all of
the S's for example