Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
great...thank you very much...I thought I tried that but obviously didn't.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying between two dates doesn't work if Start and End are ident 10
Get Followup and Followup Past Due Counts 3
minimize repeating query criteria & generating monthly YTD totals 1
Need Help soon with this querry!!!!!! PLZ PLZ 0
Date query 2
Date search query 0
Autoinsert of variable data into update query 6
Update Query for Fiscal Date range 2

Back
Top