Address Label Problem

[Saxman]

I have one more problem to solve before completing my database.

I need to save address labels to file. I know Label Wizard does this, but
my problem needs to be selective. The customers are 'active' or 'not
active' and I need to create separate labels for both.

Customer address details (Street, Town etc.) are stored on the main table
'Clients' and the active/inactive status comes from the same table
'Clients' under the 'Status' column.

I realise this might not be the best relationship, but initially the
customer wanted a one page form and now wants more.

I have posted this to comp.database.m s-access as well.

[pietlinden@hotmail.com]

Re: Address Label Problem

so base your report on a query or add a filter when you open the
report. See the DoCmd.OpenRepor t function... one of the options is a
filter - just add a valid WHERE clause, e.g. "[Status]='Active'" or
"[Status]='Inactive'"

[Saxman]

Re: Address Label Problem

On 2 Dec 2005 11:50:15 -0800, pietlinden@hotm ail.com wrote:
[color=blue]
> so base your report on a query or add a filter when you open the
> report. See the DoCmd.OpenRepor t function... one of the options is a
> filter - just add a valid WHERE clause, e.g. "[Status]='Active'" or
> "[Status]='Inactive'"[/color]

I have sorted it now. I created a query including the address fields and
'Active' field; filtered 'Active'. I then created a new label wizard from
the new query.