double data??

[AND]

hello,
I built a query:
SELECT DISTINCT CDate(Fix([w2ggina]*(48)+0.9999)/48) AS DataArrotondata,
Count(Dati.abest) AS ConteggioDiabest
FROM Dati
GROUP BY CDate(Fix([w2ggina]*(48)+0.9999)/48), Dati.w2ctr
HAVING (((Dati.w2ctr)<>"999999"));

W2ctr lists 3 type of data(999999,0000015 and 000023): I wrote <>999999 to
get the last two, but when I going to view the data, it shows me 2 lines
instead one, like here:
DataArrotondata ConteggioDiabest
02/02/2009 19.00.00 4
02/02/2009 19.30.00 2
02/02/2009 20.00.00 6
02/02/2009 20.00.00 13
02/02/2009 20.30.00 1

PLease help me! how can I get only a row for data?
thanks a lot to everyone want help me!!!

 

[John Spencer]

I would assume that you have two records for that date and time. One
for 0000015 and another for 000023.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================