group query using MAX function displays incorrect data

[gdev]

Hi,

I have a query using these fields:

date
planid
employeeid
amount

using the max function on date.

Somehow, it doesn't display the correct data and has wrong number of records.
For example it will display the amount for 12/31/2003 with the wrong date, 12/31/2004. When I remove the amount field, it will display the correct data and correct number of records.

Please help.

Thanks

Gwen

 

[traingamer]

Are your date fields defined as a 'date' type in the table? (If so, can you post your sql?)

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill