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.ms-access as well.

[pietlinden]

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

[Saxman]

On 2 Dec 2005 11:50:15 -0800, pi********@hotmail.com wrote:

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

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.