[AccessD] first five dates per year

How big is the database....zipped.  If you could send me a sample (I
shouldn't have any problem with something less then 10 megs in email), I'll
see if I can optimize it for you.

Drew

-----Original Message-----
From: Pedro Janssen [mailto:pedro at plex.nl]
Sent: Saturday, March 08, 2003 3:37 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] first five dates per year


Hello Drew and Gustav,

Drew, i indexed the date field, but the query wasn't quicker as the without
indexing. I'll have to wait 20 minutes or so, but the result is what i want.

Gustav, your query still gives me some problems.
When i use only the part of the query with Year the result is good, but the
Parameters is asking for the year and afterthat for Year5. I don't
understand this.
When i use Year and Union Year+1 i get result that don't fit.
Maybe it has something to do with the fieldnames. In your query which field
is ID and which field is DateTrans.

For example in TblTrans i only have one field [datum].