G
Guest
Hello,
I'm somewhat new to ACCESS and still trying to learn it. I'm having a
problem with a query I'm running if you could please help me out I would be
really appricative. Im trying to combine only certain records by matching up
dates from 2 different fields. I'll call the fields "date1" and "date2". My
problem is this though, there are many records with the same date in "date1"
but with different dates in "date2". I know how to simply just combine the
records by matching the dates, but I only want to combine records that have
the earliest dates in "date2" corroesponding to the "date1" field.
Here is an example:
Date1 Date2
1: 1/5/01 1/1/01
2: 1/5/01 1/1/01
3: 1/5/01 1/2/01
4: 1/5/01 1/3/01
5: 1/5/01 1/3/01
6: 1/5/01 1/4/01
7: 1/9/01 1/5/01
8: 1/9/01 1/5/01
9: 1/9/01 1/6/01
10: 1/9/01 1/7/01
11: 1/9/01 1/7/01
How do I write a query that would only combine records 1 and 2 as well as
records 7 and 8 without combining records 4 and 5 or records 10 and 11?
I only need the earliest matching dates from "date2" that correspond to a
date in "date1" to be combined.
If anyone could help me I would really appricate it. I'm stuck on this one
and any ideas you might have would really help me out. Thanks so much.
-Ian
I'm somewhat new to ACCESS and still trying to learn it. I'm having a
problem with a query I'm running if you could please help me out I would be
really appricative. Im trying to combine only certain records by matching up
dates from 2 different fields. I'll call the fields "date1" and "date2". My
problem is this though, there are many records with the same date in "date1"
but with different dates in "date2". I know how to simply just combine the
records by matching the dates, but I only want to combine records that have
the earliest dates in "date2" corroesponding to the "date1" field.
Here is an example:
Date1 Date2
1: 1/5/01 1/1/01
2: 1/5/01 1/1/01
3: 1/5/01 1/2/01
4: 1/5/01 1/3/01
5: 1/5/01 1/3/01
6: 1/5/01 1/4/01
7: 1/9/01 1/5/01
8: 1/9/01 1/5/01
9: 1/9/01 1/6/01
10: 1/9/01 1/7/01
11: 1/9/01 1/7/01
How do I write a query that would only combine records 1 and 2 as well as
records 7 and 8 without combining records 4 and 5 or records 10 and 11?
I only need the earliest matching dates from "date2" that correspond to a
date in "date1" to be combined.
If anyone could help me I would really appricate it. I'm stuck on this one
and any ideas you might have would really help me out. Thanks so much.
-Ian