selecting by date

[daz321]

i am creating an access application, using data from an oracle database, the application produces letters containing financial information (incomes/pensions etc) for that years agreement. The users would like to select the year for the agreement, but the date when each income was created (added to the database) isn't the same as the agreement date. Each income can also be updated during the agreement period (they usually last one year). Is there any way that i can select on dates, because i can't get one dates occurances of the information, i'm stuck with using greater than the agreement date, but this produces too many values (multiple financial years data).

 

[scking]

You might want to consider using the Between...And Operator documented in the help files, or generate a filter for the form.

Dim strCriteria
strCriteria = "MyDate Between #" & Date1 & "# And #" & Date2 & "#"
Me.Filter = strCriteria
Me.FilterOn = True

Date1 and Date2 could be controls on the form.

Steve King
Growth follows a healthy professional curiosity