Selective Address Labels?

[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.

 

[John Spencer]

Are you using a query as the basis of the selecting records for the labels?
If Not, then create a query with the needed fields including the Status
column.

Are you using two different label reports depending on the status (different
layouts or just different records)? From your post it appears that you are
using different layouts. So on that assumption

Open up the label report in design mode and click on the record source
property. Click on the three dots at the end and (create or ) modify the
query to filter by Status.
Add the Status field to query and set its criteria to Active or Not Active
Close the label report.

Do the same thing to the second label report - obviously changing the
criteria as appropriate.

 

[Saxman]

Are you using a query as the basis of the selecting records for the labels?
If Not, then create a query with the needed fields including the Status
column.

Are you using two different label reports depending on the status (different
layouts or just different records)? From your post it appears that you are
using different layouts. So on that assumption

At the moment I have just one report created by the 'Label Wizard'.

Open up the label report in design mode and click on the record source
property. Click on the three dots at the end and (create or ) modify the
query to filter by Status.
Add the Status field to query and set its criteria to Active or Not Active
Close the label report.

I have managed to do the above, thanks. I now have the following
expression in the Record Source via properties.

SELECT Clients.Active FROM Clients WHERE (((Clients.Active)="2"));

(2 ='Active' and 1 = 'Not Active').

I saved the report and was prompted 'Enter Parameter Value' for every
field? I clicked OK to all without entering any values, as I was not too
sure what the input should be.

Printing out the report just gives me blanks now.

Should I create a new 'Label Wizard' and start afresh?

Do the same thing to the second label report - obviously changing the
criteria as appropriate.

No problem, as soon as I can get the first report sorted!

Thanks

 

[Saxman]

Open up the label report in design mode and click on the record source
property. Click on the three dots at the end and (create or ) modify the
query to filter by Status.
Add the Status field to query and set its criteria to Active or Not Active
Close the label report.

Do the same thing to the second label report - obviously changing the
criteria as appropriate.

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.