Need help on an SQL Statement

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hello;
I want an SQL statement that return all fields,all records of
[InvoicesTABLE],but sort all records having [InvCost]>4000 at the end of
returned query.The second ordering rule is [InvDate].In fact i want to sort
all records by field [InvDate] exept for invoices with cost more than
4000,that put at the end of the returned query.
Can anyone please help me to write this SQL statement?Thank you in advance.
 
Something like this?

SELECT * FROM [InvoicesTable] ORDER BY [InvCost]>4000 DESC, [InvDate]

HTH
- Turtle
 
Thank you,Will try it.

MacDermott said:
Something like this?

SELECT * FROM [InvoicesTable] ORDER BY [InvCost]>4000 DESC, [InvDate]

HTH
- Turtle

Mota said:
Hello;
I want an SQL statement that return all fields,all records of
[InvoicesTABLE],but sort all records having [InvCost]>4000 at the end of
returned query.The second ordering rule is [InvDate].In fact i want to sort
all records by field [InvDate] exept for invoices with cost more than
4000,that put at the end of the returned query.
Can anyone please help me to write this SQL statement?Thank you in advance.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access transform x-tab SQL statement 1
Build SQL statement 2
SQL statement in form text control 2
Union question... 2
Problem with complex sql statement underlying a form 1
Union query duplicates... 5
Problems saving record to a SQL Server via VBA 4
Orderby is not working 1

Back
Top