RE: Query structure question

2002-03-01 Thread Gurhan Ozen
ohn Hughes [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Query structure question I have a database that tracks letters to the editor published in my paper. The table includes a date field and a status field. Status can be either "input" or

Query structure question

2002-03-01 Thread John Hughes
I have a database that tracks letters to the editor published in my paper. The table includes a date field and a status field. Status can be either "input" or "published." What I want to do is create a report that tells me how many letters were published on each of the last 30 days. Is there a