Query Question

[Guest]

I am trying to construct a query that will sum the contents of a particular
field based on todays date. Can't seem to find any examples of this.

Select count(wins) as numtrades from table where (date = today); Obviously
the (date=today) is the problem area.

thanks Mike

 

[Guest]

Try using Now() instead of today. That should work.

 

[Guest]

great...thank you very much...I thought I tried that but obviously didn't.