Interesting one. I'm putting together some reports against the helpdesk form (v5) in Crystal, and thought I'd sanity check the results with the user tool.
For a given customer, in a given month, the two are giving different results. ie. customer="a" and 'create date' >= "01/11/2006" and 'create date' < "01/12/2006" Crystal gives more records, and it turns out that the user tool is omitting one record. That entry on the helpdesk form was created on the 30 November, but the user tool isn't including it. Any suggestions? It seems very, very strange. Regards Dave _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"