AlexTeslin
Registered User.
- Local time
- Today, 07:09
- Joined
- Jul 10, 2008
- Messages
- 55
Hi,
I am trying to pull records from tables which have the same dates within a field in a table. For example if a table has following records:
Field_1 Field_2
ref1 date1
ref2 date2
ref3 date3
ref1 date2
The query should output only 2 records (ref2, date2) and (ref1, date2), because both dates are the same even though the ref are different.
My question is how can I pull only those 2 records so that somehow it can loop within the date field?
Thank you in advance
I am trying to pull records from tables which have the same dates within a field in a table. For example if a table has following records:
Field_1 Field_2
ref1 date1
ref2 date2
ref3 date3
ref1 date2
The query should output only 2 records (ref2, date2) and (ref1, date2), because both dates are the same even though the ref are different.
My question is how can I pull only those 2 records so that somehow it can loop within the date field?
Thank you in advance