Error in tutorial # 34.

[Lou_Reed]

In the tutorial listed here: http://www.functionx.com/access/Lesson34.htm.

I should have the output

SQL statement:

SELECT Customers.CustomerID,
Customers.AccountNumber AS [Account #],
Customers.FullName AS [Customer Name]
FROM Customers;

However, I have the following SQL statement:

SELECT Customers.CustomerID,
Customers.AccountNumber AS [Account #],
Customers.FullName AS [Customer Name]
FROM Customers ORDER BY Customers.[AccountNumber];

I am not sure if this "ORDER BY Customers.[AccountNumber] : is even important
I is just at the end of my SQL code and not shown in the tutorial. is it relevant?


Is just another typo in this tutorial?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

If you created the query in design view, you added a sort in the Sort row. You can delete that if you want, and only lose the sorting.

[June7]

Then why is ORDER BY in query if not instructed to do it?

I doubt record order is relevant or will have any impact on your progress through the tutorial.

This tutorial uses spaces and special characters/punctuation in names. Advise not to follow this convention, even with alias names. Only exception is the underscore.

[Lou_Reed]

How do I delete the sort in the Sort row?

R,

Lou Reed

In other words, how do I change this?

[June7]

Select (not sorted) in the Sort: row dropdown.

[Lou_Reed]

Please be more explicit.

Do I have to make that whole tutorial section over again? Can I not just change sort to not sorted or something like that?

Thanks in advance.

R,

Lou Reed

[June7]

Basic Access functionality. Open query object in design view, modify as you see fit.