How assign auto serial number for each user by certain date?

[latifju]

My data are here

ID	User	TRNUM	EntryDate	Cash
1	A	1121	25/10/13	2000
2	A	1211	25/10/13	2500
3	B	1211	25/10/13	8470
4	C	2210	25/10/13	1440
5	B	1211	26/10/13	1000
6	A	2540	26/10/13	5400
7	C	2540	26/10/13	1400
8	B	1211	26/10/13	1000

Now i need to find all record of user "A" on date 25/10/2013 with a auto serial number starting from 1. User and Date will come from a table.

Thanks in advance

[June7]

Thread title doesn't really match the narrative.

Maybe:

SELECT * FROM tablename WHERE User="A" AND EntryDate=#10/25/2013# AND TRNUM LIKE "1*";