Newbie Question

[dlokko]

Hi all,

I just started with Access 2000 and I am using the sample
address book for a client address database. I have been
able to import my data from excel and I can print labels
using the default label report...however when I do this it
print's ALL the clients. I would like to be able to print
the labels based off of clients in a certain city or maybe
another criteria....etc.

Any ideas on how to do this is much appreciated. Thank you
in advance.

 

[GVaught]

Create a query based on the main customer table using the fields you need.
You can enter a parameterized query by entering under the appropriate field,
such as city the following: Like [Enter City] & "*". The Like allows you to
enter partial values and the & * add the appropriate wildcard to allow that
partial entry. If you press Enter on your keyboard without entering any
value in the popup box all cities will be returned. This feature is not
good for having to enter multiple cities as criteria.

If you were using zipcode as a criteria you could use: Between [Enter
Starting zipcode] AND [Enter ending zipcode] to pick a zipcode range as the
criteria rather than using the City criteria mention above.

Good Luck.

 

[Ed Robichaud]

Sure, this is most easily done by using a query (and not the whole table) as
the record source for your report/labels.
Use the query wizard to build a "select" query based on your table of
addresses. Follow the prompts, and in the [city] or [zip] columns of your
query, specify which city (i.e. "Columbus") or zip code range (i.e. between
20100 and 45005) to filter a portion of your table to print.

Look at the Help section of Access for "parameter" queries, as it will
explain how to design a query that will prompt you for the selection
criteria each time it is run. That way, when you print your labels, a
dialog box will ask for the city and/or zip you want.

Good luck
-Ed

 

[Craig Williams]

From the little bit that I know and have read, helping someone with a
database problem that wishes to do something that the client wasn't
designed to do, isn't so easy to explain on how to make those changes.

Thoughts anyone?

Craig Williams
(e-mail address removed)