Printing information that start with a particular letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Brian

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

Brian said:
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.

Smokey smith said:
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
Click to expand...
Click to expand...
 
Back
Top