L
Leo
I asked this question before, and didn't get an answer so here it is again
simplified
If I have three fields
code indetifier date
H67 P 03/02/2005
H67 Q 03/02/2005
H67 P 01/02/2005
H67 Q 01/02/2005
H67 P 11/02/2004
H67 Q 11/02/2004
The records are sorted by date (mm/dd/yyyy)
If you notice there is two of the same codes but different identifiers for
each month
However I only want to return these records based on a specific criteris. So
say if this criteria says 2 then I only want the last two months from the
query like below:
H67 P 03/02/2005
H67 Q 03/02/2005
H67 P 01/02/2005
H67 Q 01/02/2005
so only records with dates 03/02/2005 and 01/02/2005
if the criteria says 3, then all the above records would be returned
Does anyone have any idea how I could do that using VBA?
Thanks a lot
Leo
simplified
If I have three fields
code indetifier date
H67 P 03/02/2005
H67 Q 03/02/2005
H67 P 01/02/2005
H67 Q 01/02/2005
H67 P 11/02/2004
H67 Q 11/02/2004
The records are sorted by date (mm/dd/yyyy)
If you notice there is two of the same codes but different identifiers for
each month
However I only want to return these records based on a specific criteris. So
say if this criteria says 2 then I only want the last two months from the
query like below:
H67 P 03/02/2005
H67 Q 03/02/2005
H67 P 01/02/2005
H67 Q 01/02/2005
so only records with dates 03/02/2005 and 01/02/2005
if the criteria says 3, then all the above records would be returned
Does anyone have any idea how I could do that using VBA?
Thanks a lot
Leo