Product: LABELVIEW, CODESOFT
Version: All Versions
|
|
Example:
To show Quantity, Ingredient, Full Cases and then Partial Cases in the following query
SELECT [Quantity],[Full Cases],[Partial Cases],[Ingredient] FROM [Sheet1$] AS Sheet1_
Rearrange the SELECT statement as such:
SELECT [Quantity],[Ingredient],[Full Cases],[Partial Cases] FROM [Sheet1$] AS Sheet1_
1. With a label open that is connected to a database, click on Database and select Create/Edit Query.
2. Select SQL for the creation mode.
3. Click on the Query Result button to see the current column order.
4. Reorder the data from the SELECT statement as necessary.
5. Click the Query Result button to see the new order of the columns based on the SQL order. Close the query window.
6. Click OK.
7. Press Yes to save the query.
8. Select a filename and press Save.
9. The query result will now show columns in the new order.
|
|