Printing help

losthome

Registered User.
Local time
Today, 20:16
Joined
May 17, 2002
Messages
25
Hi there,

I have a database that allows you to filter last names. How do I setup the report to just display the filter choice and print that choice? For example, you choose B and all people with last names with B's come up. When I preview the report, it shows A-Z, how do I get it to just show the B's?

Thank you,
Jen
 
Do this:

Like "b*" in your query and it will only show all the last names that start with B
smile.gif


Sohiala
 
Okay, I need to explain myself abit more. I have a form that has macros to filter a-z and all from a querie of last names. What I want to do is when I pick B in the form and click a preview button to preview a report on my selection, it doesn't Preview just the B's, it previews all. How do I preview and print just what I select?
 
In your query behinde the report put in the like statement like this:
like [Enter your last name],
Now if the user opens up the report, it will ask them to "Enter your last name" and if they put in b* for instance, it will show them all the last names that start with b. I hope I answered your question correctly.

Sohaila
 
I think what you are looking for can be found in the Northwind Database. Look at the customer phone list in the macro section and how they have filtered and in the form Customer phone list, where they have applied it. I missunderstood your question.

Sohaila
 

Users who are viewing this thread

Back
Top Bottom