Time sort

[libin04]

can you anyone help to create MS Quarry to short the time i mean ascending descending in the quarry .

 

[Gasman]

Is it within 24 hours?

 

[cheekybuddha]

Yes, most people here can help.

But you will need to provide more details.

What have you tried already?

What is the table/tables involved?

What are the field names and their datatypes?

 

[arnelgp]

you can try with Normal query:
ascending

SELECT * FROM yourTableName ORDER BY TheShortTimeField ASC;

or, descending:

SELECT * FROM yourTableName ORDER BY TheShortTimeField DESC;

 

[libin04]

Yes, most people here can help.

But you will need to provide more details.

What have you tried already?

What is the table/tables involved?

What are the field names and their datatypes?

Hi Cheeky Buddha, I have attached the DB. kindly check in Quarry name "HI" I am trying to bring IN time and OUT time.

 

[arnelgp]

SELECT Activity.*
FROM Activity
ORDER BY Activity.Cdate, Activity.Stime;

 

[libin04]

SELECT Activity.*
FROM Activity
ORDER BY Activity.Cdate, Activity.Stime;

can be set in the Quarry ?

 

[Gasman]

can be set in the Quarry ?

That is the query?

 

[arnelgp]

can be set in the Quarry ?

you mean the Beatles?

 

[libin04]

you mean the Beatles?

if you check design mode of the query, there will be the condition which we can give.
can we set there?