Query based on union

[haroon.mansha]

Hi
I have made a union query based on two different queries
I have made a stock register with date description receipts issued

Now i want if receipt and issued dates are same receipts should ahow first
Can you give idea how i can do it
Thanks in advance

 

[jdraw]

Suggest you show an example to help readers understand your situation and requirement.

 

[haroon.mansha]

Ok i will upload it soon so you
can see.
But in short what i want to show below to

Date. Description receipts issued
01/01/2014 sales abc. 0. 10
01/01/2014 purchase 10 0

As you see sales and purchase same date but sales shown first while what i want purchase row to be first

 

[Gasman]

Hi,
I would add the value 1 as an extra field for the purchase query and 2 for the sales query then use that field in your sorting.

HTH

 

[haroon.mansha]

Means first it will sort date and then sort by extra field

 

[Gasman]

The sort sequence is up to you, but yes, if that is all you need, then it will sort them in the order you wish.