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