Multiple Labels from customer record.

[pizzaboy]

Hey all, I've been using this site for at least 2 years and this is actually the first time I have potsed. I have built a small - medium company database (4895 customer records) largely with the help of this site!

Anyway here is my problem.....

Our company sells products to schools and some customers can buy several products which need separate lables (with cust details) to identify them - believe it or not we currently write the customers details on pre-printed lables by hand!!!!!

At the moment I have set a system for creating lables using a search query in the database (to search out all the customers for a given school) and an avery lable maker plugin to create the lables from the query. However this only creates one lable per customer.

How could I set up a system that creates a lable for each product a customer has?

The database is built quite simply and the customers details are one line per cust record. field by field across one table in the database.

Any help would be most appreciated. Pic of one of our customer records shown below if it helps.

 

[Steve R.]

At the moment I have set a system for creating lables using a search query in the database (to search out all the customers for a given school) and an avery lable maker plugin to create the lables from the query. However this only creates one lable per customer.

I am not an SQL expert, but it appears that your search criteria is backwards.

I would suggest something along the lines of

SELECT all products FROM SomeQuery WHERE the Customer = XX

Addtionally if you want it by school

SELECT all products FROM SomeQuery WHERE the Customer = XX AND School = ZZ

It occurred to me that I forgot the FROM clause. You will need to create a a query that has Products, Customer, and School as fields, plus any other information that you may want to display on your label. You should then be able to use the SQL statement as the record source for a report that prints to Avery labels.

If you want to directlry retrieve data from your tables without the intermediary query, you will need to review the types of queries available in Access help.

 

[axle124]

just create a query, I would probably add a field to your table whether it be a dateprint field or a checkbox or something like that. Then on your form on the click event where you print your label update the date print field of your table ie dateprint = date(which returns todays date). Of course the form that you have for the label would need to be based on the query.

where yourcustomer(subsitute this for your fieldname) = entercustomer and dateprinted is null

That would allow you to query the information for the customer that has not been printed.