SQL - Creating Labels

You can easily create labels from your queries just as easy as a report. Simply create a query of up to 5 columns and select Labels instead of Report after executing the query. Each column is placed as a row in the label, up to five. Anything over five is simply ignored.

In this query example, labels are created from reservations (RESERVE table) that have a ZIPcode and are active reservations.

SELECT CONCAT(FIRSTNAME,' ',LASTNAME) AS 'NAME',STREET ,CONCAT(CITY,', ',STATE,' ',ZIPCODE) AS 'ADDRESS2', COUNTRY

FROM RESERVE

where zipcode <> '' and reservestatus = 'R'

order by zipcode

In this above example, concatenation is used to bring the Firstname and Lastname together with a space. The same is done with the City, State and ZIPCode with a comma ', ' in between the city and state.

Blank Labels is used to create any number of blank labels before printing the first label. This is useful if you are using an existing sheet of labels that have already been used and you want to start the label printing on say the 10th label.

Max Columns - Enter the maximum number of columns to include in your labels. This is helpful is the query is selecting more (extra) columns than what you actually want to include in your labels.

Bold first line of each label can be used if you want the first row of each label bolded. This may be useful for rooming labels or you just want the person's name bolded in your mailing.

Float blank lines upwards will automatically float information on each row upward if the row above it is blank. This stops blank lines from being printed such as when you are using Street1 and Street2.

Combine First and Last name will allow you to take two columns (next to each other) and combine them with a space between them. (ie: John in COLUMN1 and Smith in COLUMN2 will show up on the first line as John Smith.

Combine City, State and ZIP/Postal will allow you to take three columns (next to each other) and combine them to a formatted address (Anytown in COLUMN4 and CT in COLUMN5 and 06111 in COLUMN6 will show up on the line as Anytown, CT 06111