Get First date from a set of record

[msun65]

Please help me create a function to

1. returns a value of 1 if the expression ("date") is the first date
from a specified set of records.
2. returns a value of 2 if the "date" is the second date from a
specified set of records that meets the following criteria:

 

[msun65]

On Jun 16, 7:59 pm, (e-mail address removed) wrote:
Please help me create a function to

1. returns a value of 1 in a query if the expression ("RecDate") is
the first date
from a specified set of records.
2. returns a value of 2 in a query if the "RecDate" is the second
date from a
specified set of records that meets the following criteria:
a. the year of the subsequent record does not equal the year of the
first "date"
b. the subsequent record is equal or less the 3 years of the first
"RecDate"
c. the subsequent record does not equal "GLyear" of the first
"RecDate"'s "GLyear"

If item 2 above does not meet the criteria, it returns a value of 0 in
a query.

 

[Steve]

Why don't you back up and tell us what you want to accomplish. What you are
trying to do in your post seems to be convoluted.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)