Mike,

Regarding my Email address, I got so much spam when I posted my Email
address on this forum so I decided not to. Besides, I can't see the
relevancy of my Email to this at all.

Now, what you suggest will choose all the records with the date July/03.
What I need is not to have them selected by the date but grouped by a
certain date. I will give you an example. Suppose I have a 'date' field and
a 'sum' field. What I need is a report about the total sum in each month.
And I wonder what is the most simple way to do it.

Regards,
Albert Ahtenberg

"Mike Vore" <mvore@ix.netcom.cam> wrote in message
news:slrnbfr1ln.sqp.mvore@snowmass.mystic.ct...
>
> First get a real email address if you want real replies.
>
> On Fri, 27 Jun 2003 20:54:25 -0400, Albert <donotcontact@this.address>
wrote:
> > It is the MySql DATE type. looks like (DD-MM-YYYY).
> ^^^^^^^^^^
> This isn't a MySQL date format.
>
>
> select * from mydatabase where datefield like "2003-07%";
>
> This works for me.
>
>
> >
> > "Steven James Samuel Stapleton" <stapleton.41@mps.ohio-state.edu> wrote
in
> > message news:mcgHx12drhfu@ohstpy...
> >> What format is the date field stored in?
> >>
> >> Is there a day, month, and year field (separate)?
> >> Is it a timestamp?
> >> Is it something else?
> >>
> >> -Jim Stapleton
> >>
> >> "Albert Ahtenberg" <donotcontact@this.address> wrote in message
> >> news:bdhud4$tev$1@tabloid.uwaterloo.ca...
> >> > Hi,
> >> >
> >> > I have a database with a date field. And I would like to see the
report
> >> > grouped by a ceratin month and year, how can I do that without
multiple
> >> > queries?
> >> >
> >> > Albert Ahtenberg
> >> >
> >> >
> >>
> >>
> >
> >
>
>
> --
> Michael Vore, W3CCV M-ASA [Ka8]; WHIRL, ABC; CAW, CW, AAW
> http://mike.vorefamily.net/ohmywoodness <-Custom Woodworking
> http://mike.vorefamily.net/thewoodenradio <-The weblog