Description
Customer name, order date, and freight charge for each order.
View properties
| name | value |
|---|
| name | ~sq_fCustomer Orders Subform1 |
| created | 8/16/2008 9:50:02 PM |
| modified | 8/16/2008 9:50:02 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| OrderID | long | 4 | yes
| Unique order number.
|
| CustomerID | text | 5 | yes
| Same entry as in Customers table.
|
| EmployeeID | long | 4 | yes
| Same entry as in Employees table.
|
| OrderDate | datetime | 8 | yes
| |
| RequiredDate | datetime | 8 | yes
| |
| ShippedDate | datetime | 8 | yes
| |
| ShipVia | long | 4 | yes
| Same as Shipper ID in Shippers table.
|
| Freight | currency | 8 | yes
| |
| ShipName | text | 40 | yes
| Name of person or company to receive the shipment.
|
| ShipAddress | text | 60 | yes
| Street address only -- no post-office box allowed.
|
| ShipCity | text | 15 | yes
| |
| ShipRegion | text | 15 | yes
| State or province.
|
| ShipPostalCode | text | 10 | yes
| |
| ShipCountry | text | 15 | yes
| |
Dependency graph
Objects that ~sq_fCustomer Orders Subform1 depends on
Sample rows
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
|---|
| 10248
| VINET
| 5
| 8/4/1994 12:00:00 AM
| 9/1/1994 12:00:00 AM
| 8/16/1994 12:00:00 AM
| 3
| 32.38
| Vins et alcools Chevalier
| 59 rue de l'Abbaye
| Reims
| NULL
| 51100
| France
|
| 10249
| TOMSP
| 6
| 8/5/1994 12:00:00 AM
| 9/16/1994 12:00:00 AM
| 8/10/1994 12:00:00 AM
| 1
| 11.61
| Toms Spezialitäten
| Luisenstr. 48
| Münster
| NULL
| 44087
| Germany
|
| 10250
| HANAR
| 4
| 8/8/1994 12:00:00 AM
| 9/5/1994 12:00:00 AM
| 8/12/1994 12:00:00 AM
| 2
| 65.83
| Hanari Carnes
| Rua do Paço, 67
| Rio de Janeiro
| RJ
| 05454-876
| Brazil
|
| 10251
| VICTE
| 3
| 8/8/1994 12:00:00 AM
| 9/5/1994 12:00:00 AM
| 8/15/1994 12:00:00 AM
| 1
| 41.34
| Victuailles en stock
| 2, rue du Commerce
| Lyon
| NULL
| 69004
| France
|
| 10252
| SUPRD
| 4
| 8/9/1994 12:00:00 AM
| 9/6/1994 12:00:00 AM
| 8/11/1994 12:00:00 AM
| 2
| 51.3
| Suprêmes délices
| Boulevard Tirou, 255
| Charleroi
| NULL
| B-6000
| Belgium
|
| 10253
| HANAR
| 3
| 8/10/1994 12:00:00 AM
| 8/24/1994 12:00:00 AM
| 8/16/1994 12:00:00 AM
| 2
| 58.17
| Hanari Carnes
| Rua do Paço, 67
| Rio de Janeiro
| RJ
| 05454-876
| Brazil
|
| 10254
| CHOPS
| 5
| 8/11/1994 12:00:00 AM
| 9/8/1994 12:00:00 AM
| 8/23/1994 12:00:00 AM
| 2
| 22.98
| Chop-suey Chinese
| Hauptstr. 31
| Bern
| NULL
| 3012
| Switzerland
|
| 10255
| RICSU
| 9
| 8/12/1994 12:00:00 AM
| 9/9/1994 12:00:00 AM
| 8/15/1994 12:00:00 AM
| 3
| 148.33
| Richter Supermarkt
| Starenweg 5
| Genève
| NULL
| 1204
| Switzerland
|
| 10256
| WELLI
| 3
| 8/15/1994 12:00:00 AM
| 9/12/1994 12:00:00 AM
| 8/17/1994 12:00:00 AM
| 2
| 13.97
| Wellington Importadora
| Rua do Mercado, 12
| Resende
| SP
| 08737-363
| Brazil
|
| 10257
| HILAA
| 4
| 8/16/1994 12:00:00 AM
| 9/13/1994 12:00:00 AM
| 8/22/1994 12:00:00 AM
| 3
| 81.91
| HILARIÓN-Abastos
| Carrera 22 con Ave. Carlos Soublette #8-35
| San Cristóbal
| Táchira
| 5022
| Venezuela
|
Code
SELECT DISTINCTROW
*
FROM Orders;