How to create a Serial Numbers in Union Query from Merged Query’s?

[sandya]

Hello, Can anyone solve this problem.

I was Merged 4 queries in a Union query. So in this case i need a serial numbers that which query data is first stored in union query that basis i need to create serial numbers from 4 queries data stored as 1st priority basis. how to make this Issue? :banghead:

Thanks,
Sandhya.

 

[pr2-eugin]

Could you please give some examples?

 

[sandya]

thanks for respond. i have attached the screenshot as per my merged query details. and mentioned in last column which record is 1st, 2nd, 3rd stored in union query that basis i need to create a serial numbers.

 

[JHB]

Sorry - I get you lost!

 

[sandya]

Sorry - I get you lost!

am not understing... what you lost for me?

 

[pr2-eugin]

You are not making any sense Sandya. Your description is confusing, so is your example.

 

[spikepl]

You need to show the data you start off with (the initial data: result of your UNION, presumably) and the end result - not just a story but the actual expected result corresponding to the initial data.

 

[sandya]

sorry for the confused for every one

Now i can explain very clearly

I have attached Db file. Can you please once open it and go to Query: BT_Qry1 this is normal query source from Query: BT_UnionQry1
In the BT_Qry1 Data are stored 9 records and it source from below following user forms (Data entry forms) i.e.

Data Entry forms:
PAY_1
PAY_2
REC_1
REC_2
BT_DepositEntry
BT_WithdrawEntry

So above user forms is uses depends on users and that data shown in BT_Qry1.

Now that data I need to show a serial wise that means if user using first of all REC_1 form for data entry that record is need to create as serial number 1 in BT_Qry1 Or user using another form Like PAY_1 or PAY_2 or REC_2 & anything that data entry forms is using basis automatically create serial numbers in BT_Qry1

Just i need a serial numbers in Query: BT_Qry1 which data is first stored as serial wise

For Exmple:

Now Present shown a data in Query: BT_Qry1 without serial but I have entered the data below format. Just mentioned only Amounts not all filed details…

1. 32,222
2. 14,777
3. 19,882
4. 11,552
5. 5,656
6. 2,322
7. 1,515
8. 4,545
9. 2,120
10. 3,256

I have entered the Data this serial wise but data shown without serial in Query: BT_Qry1

 

[JHB]

How do you decide it should be in this order, try to explain it, use the result from the final query (I've read you explanation but can't still get it) ?

1. 32,222
2. 14,777
3. 19,882
4. 11,552
5. 5,656
6. 2,322
7. 1,515
8. 4,545
9. 2,120
10. 3,256

 

[sandya]

Actually Users that data is entered from Manual book (Daily Cash In & Out). They are entered the data as per book manual & Order wise.

We are easily find-out with ID Numbers which data is is latest record in the normal query. Then some of query's merged in the UNION Query that time how to find the latest record in the union query?

That's way am asking you how to find the latest record in the union query? If any possible to create serial numbers separately with latest entry record wise in Union Query?