Open a Label Specification
CustomersKids
CustomersOrders
Example1
NorthwindEmployees
DataBase
Select A Database
C:\My Documents\ReportLabelSpecs.mdb
Northwind
Build label contents by selecting fields from the Fields list or typing in field names. Defaults to one field per line. Concatenate field names by inserting an & (Access) or a + (SQL Server) after a line contents, before selecting next field. Access: 1. lname 2. fname & " " & lname 3. city & ", " & state & " " & zip. SQL Server: 1. lname 2. fname + ' ' + lname 3. city + ", ' + state + ' ' + zip.
And
Note: Will overwrite current filter
And
Equals
Greater Than
Less Than
Between
Not Equal
IN
NOT IN
And
Or
Equals
Greater Than
Less Than
Between
Not Equal
IN
NOT IN
And
Equals
Greater Than
Less Than
Between
Not Equal
IN
NOT IN
And
Or
And
Or
Equals
Greater Than
Less Than
Between
Not Equal
IN
NOT IN
And
Lines in Label
EmployeeID
LastName
FirstName
Title
TitleOfCourtesy
BirthDate
HireDate
Address
City
Region
PostalCode
Country
HomePhone
Extension
Photo
Notes
ReportsTo
PhotoPath
1
2
3
4
5
6
7
8
9
Line Content
Line Font
Arial 10
Arial 10 Bold
Arial 10 Italic
Arial 10 Bold Italic
Arial 12
Arial 12 Bold
Arial 12 Italic
Arial 12 Bold Italic
Arial 14
Arial 14 Bold
Arial 14 Italic
Arial 14 Bold Italic
Comic Sans MS 12
Comic Sans MS 12 Bold
Comic Sans MS 12 Italic
Comic Sans MS 12 Bold Italic
Comic Sans MS 14
Comic Sans MS 14 Bold
Comic Sans MS 14 Italic
Comic Sans MS 14 Bold Italic
Comic Sans MS 16
Comic Sans MS 16 Bold
Comic Sans MS 16 Italic
Comic Sans MS 16 Bold Italic
Times New Roman 10
Times New Roman 10 Bold
Times New Roman 10 Italic
Times New Roman 10 Bold Ita.
Times New Roman 12
Times New Roman 12 Bold
Times New Roman 12 Italic
Times New Roman 12 Bold Ita.
Times New Roman 14
Times New Roman 14 Bold
Times New Roman 14 Italic
Times New Roman 14 Bold Ita.
Times New Roman 16
Times New Roman 16 Bold
Times New Roman 16 Italic
Times New Roman 16 Bold Ita.
Verdana 10
Verdana 10 Bold
Verdana 10 Italic
Verdana 10 Bold Italic
Verdana 12
Verdana 12 Bold
Verdana 12 Italic
Verdana 12 Bold Italic
Verdana 14
Verdana 14 Bold
Verdana 14 Italic
Verdana 14 Bold Italic
Verdana 16
Verdana 16 Bold
Verdana 16 Italic
Verdana 16 Bold Italic
Arial 10
Arial 10 Bold
Arial 10 Italic
Arial 10 Bold Italic
Arial 12
Arial 12 Bold
Arial 12 Italic
Arial 12 Bold Italic
Arial 14
Arial 14 Bold
Arial 14 Italic
Arial 14 Bold Italic
Comic Sans MS 12
Comic Sans MS 12 Bold
Comic Sans MS 12 Italic
Comic Sans MS 12 Bold Italic
Comic Sans MS 14
Comic Sans MS 14 Bold
Comic Sans MS 14 Italic
Comic Sans MS 14 Bold Italic
Comic Sans MS 16
Comic Sans MS 16 Bold
Comic Sans MS 16 Italic
Comic Sans MS 16 Bold Italic
Times New Roman 10
Times New Roman 10 Bold
Times New Roman 10 Italic
Times New Roman 10 Bold Ita.
Times New Roman 12
Times New Roman 12 Bold
Times New Roman 12 Italic
Times New Roman 12 Bold Ita.
Times New Roman 14
Times New Roman 14 Bold
Times New Roman 14 Italic
Times New Roman 14 Bold Ita.
Times New Roman 16
Times New Roman 16 Bold
Times New Roman 16 Italic
Times New Roman 16 Bold Ita.
Verdana 10
Verdana 10 Bold
Verdana 10 Italic
Verdana 10 Bold Italic
Verdana 12
Verdana 12 Bold
Verdana 12 Italic
Verdana 12 Bold Italic
Verdana 14
Verdana 14 Bold
Verdana 14 Italic
Verdana 14 Bold Italic
Verdana 16
Verdana 16 Bold
Verdana 16 Italic
Verdana 16 Bold Italic
Arial 10
Arial 10 Bold
Arial 10 Italic
Arial 10 Bold Italic
Arial 12
Arial 12 Bold
Arial 12 Italic
Arial 12 Bold Italic
Arial 14
Arial 14 Bold
Arial 14 Italic
Arial 14 Bold Italic
Comic Sans MS 12
Comic Sans MS 12 Bold
Comic Sans MS 12 Italic
Comic Sans MS 12 Bold Italic
Comic Sans MS 14
Comic Sans MS 14 Bold
Comic Sans MS 14 Italic
Comic Sans MS 14 Bold Italic
Comic Sans MS 16
Comic Sans MS 16 Bold
Comic Sans MS 16 Italic
Comic Sans MS 16 Bold Italic
Times New Roman 10
Times New Roman 10 Bold
Times New Roman 10 Italic
Times New Roman 10 Bold Ita.
Times New Roman 12
Times New Roman 12 Bold
Times New Roman 12 Italic
Times New Roman 12 Bold Ita.
Times New Roman 14
Times New Roman 14 Bold
Times New Roman 14 Italic
Times New Roman 14 Bold Ita.
Times New Roman 16
Times New Roman 16 Bold
Times New Roman 16 Italic
Times New Roman 16 Bold Ita.
Verdana 10
Verdana 10 Bold
Verdana 10 Italic
Verdana 10 Bold Italic
Verdana 12
Verdana 12 Bold
Verdana 12 Italic
Verdana 12 Bold Italic
Verdana 14
Verdana 14 Bold
Verdana 14 Italic
Verdana 14 Bold Italic
Verdana 16
Verdana 16 Bold
Verdana 16 Italic
Verdana 16 Bold Italic
Arial 10
Arial 10 Bold
Arial 10 Italic
Arial 10 Bold Italic
Arial 12
Arial 12 Bold
Arial 12 Italic
Arial 12 Bold Italic
Arial 14
Arial 14 Bold
Arial 14 Italic
Arial 14 Bold Italic
Comic Sans MS 12
Comic Sans MS 12 Bold
Comic Sans MS 12 Italic
Comic Sans MS 12 Bold Italic
Comic Sans MS 14
Comic Sans MS 14 Bold
Comic Sans MS 14 Italic
Comic Sans MS 14 Bold Italic
Comic Sans MS 16
Comic Sans MS 16 Bold
Comic Sans MS 16 Italic
Comic Sans MS 16 Bold Italic
Times New Roman 10
Times New Roman 10 Bold
Times New Roman 10 Italic
Times New Roman 10 Bold Ita.
Times New Roman 12
Times New Roman 12 Bold
Times New Roman 12 Italic
Times New Roman 12 Bold Ita.
Times New Roman 14
Times New Roman 14 Bold
Times New Roman 14 Italic
Times New Roman 14 Bold Ita.
Times New Roman 16
Times New Roman 16 Bold
Times New Roman 16 Italic
Times New Roman 16 Bold Ita.
Verdana 10
Verdana 10 Bold
Verdana 10 Italic
Verdana 10 Bold Italic
Verdana 12
Verdana 12 Bold
Verdana 12 Italic
Verdana 12 Bold Italic
Verdana 14
Verdana 14 Bold
Verdana 14 Italic
Verdana 14 Bold Italic
Verdana 16
Verdana 16 Bold
Verdana 16 Italic
Verdana 16 Bold Italic
Sort Order
Label Lines
Select a Table or View
Tables:
Categories
CustomerCustomerDemo
CustomerDemographics
Customers
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories
Views:
Alphabetical list of products
Category Sales for 1997
Current Product List
Customer and Suppliers by City
CustomerOrders_vw
Invoices
Order Details Extended
Order Subtotals
Orders Qry
Product Sales for 1997
Products Above Average Price
Products by Category
Quarterly Orders
Sales by Category
Sales Totals by Amount
Summary of Sales by Quarter
Summary of Sales by Year
H, W, Across
Top Border (in)
Horiz. Space bet. Labels (in)
Vert. Space bet. Labels (in)
Left Border, Margin (in)
Table and Fields
EmployeeID
Create New Label Spec
All Purpose Labels
5160: 1 x 2 5/8 - 3 cols
5161: 1 x 4 - 2 cols
5162: 1 1/3 x 4 - 2 cols
3 1/3 x 4 - 2 cols
5 1/2 x 4 1/4 - 2 cols
Shipping Labels
5163: 2 x 4 - 2 cols
5164: 3 1/3 x 4 - 2 cols
Name Badge Labels
5383: 2 1/3 x 3 3/8 - 2 cols
5384: 3 x 4 - 2 cols
Diskette Labels - 3 1/2"
2 3/4 x 2 3/4 - 3 cols
Diskette Labels - 5 1/4"
1 1/2 x 4 - 2 cols
Custom
Name
Replace
New
Delete
Run
Align
Top Left
Top Center
Top Right
Middle Left
Middle Center
Middle Right
Bottom Left
Bottom Middle
Bottom Right
Pg Brk
Build Filter Condition