Count *

[Crocdundee]

Can someone please help me here,Counting total records

I am trying to put a count in textbox5 on a form from this sql code.

SELECT SELECTIONS.Track, SELECTIONS.RNO, SELECTIONS.TAB, SELECTIONS.HORSE, SELECTIONS.Jockey, SELECTIONS.Odds, SELECTIONS.RATING, Ozeform.WNO, Ozeform.[_2ND], Ozeform.[_3RD], Ozeform.NSW_W, Ozeform.NSW_P, Ozeform.NSW2, Ozeform.NSW3
FROM SELECTIONS INNER JOIN Ozeform ON (SELECTIONS.Track = Ozeform.TRACK) AND (SELECTIONS.RNO = Ozeform.RNO)
WHERE (((SELECTIONS.TAB)=[wno]) AND ((Ozeform.RDATE)=[Forms]![Form1]![Combo25])) OR (((SELECTIONS.TAB)=[_2nd])) OR (((SELECTIONS.TAB)=[_3rd]))
ORDER BY SELECTIONS.RcTime;
Appreciate any help here

 

[jackd]

What exactly is this SQL suppose to represent?

Have you looked at the DCount function?

 

[Crocdundee]

ok, thanks for the reply.
First of all I can count records by Count(*) off the first query
However I have changed my mind by creating a summary form
I will do the summaries in the footer of the report
I will try dcount also

Will be back

Graham
Thanks

 

[Crocdundee]

Ok JackD, Thanks for your interest, and I have been trying hard to get this, and I have.
In a report footer i have textboxes to fill the summaries.
First I count all records (filtered by a date)
Count(*)
then i use a sum for the next TBox
=(Int(Sum(IIf([TAB]=[WNO],1,0))))
etc etc and it works
Thanks
Graham

 

[jackd]

Glad you got it working.