[AccessD] first five dates per year

Pedro Janssen pedro at plex.nl
Sat Mar 8 15:37:00 CST 2003


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].


More information about the AccessD mailing list