Prev: id is not an index in this table
Next: linking tables from different Access templates?
From: Calif_Mike on 17 Mar 2010 15:27
I have water quality data that is stored at 15 minute intervals. I would
like to query it as an hourly average. Date and time stored together as
mm/dd/yyyy hh:mm. Water quality is stored as "SiteName_EC".

The query wisard will develop daily, monthly and yearly but not hourly
queries.

Thanks,
Mike
From: Jerry Whittle on 17 Mar 2010 16:34
A report can group things down to the minute and hour level.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Calif_Mike" wrote:

> I have water quality data that is stored at 15 minute intervals. I would
> like to query it as an hourly average. Date and time stored together as
> mm/dd/yyyy hh:mm. Water quality is stored as "SiteName_EC".
>
> The query wisard will develop daily, monthly and yearly but not hourly
> queries.
>
> Thanks,
> Mike
From: Arvin Meyer [MVP] on 17 Mar 2010 17:35
I am unfamiliar with that wizard, but it seems that you could sort on the
date/time field, decending, then use the Daily query and change it by
dividing by 24.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Calif_Mike" <Calif_Mike(a)discussions.microsoft.com> wrote in message
news:4309237B-3B7F-44EE-B0EC-2FCB9A787FC8(a)microsoft.com...
>I have water quality data that is stored at 15 minute intervals. I would
> like to query it as an hourly average. Date and time stored together as
> mm/dd/yyyy hh:mm. Water quality is stored as "SiteName_EC".
>
> The query wisard will develop daily, monthly and yearly but not hourly
> queries.
>
> Thanks,
> Mike


From: Calif_Mike on 17 Mar 2010 16:58
I need the data in a format that I can work with it in Excell.

"Jerry Whittle" wrote:

> A report can group things down to the minute and hour level.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Calif_Mike" wrote:
>
> > I have water quality data that is stored at 15 minute intervals. I would
> > like to query it as an hourly average. Date and time stored together as
> > mm/dd/yyyy hh:mm. Water quality is stored as "SiteName_EC".
> >
> > The query wisard will develop daily, monthly and yearly but not hourly
> > queries.
> >
> > Thanks,
> > Mike
From: John Spencer on 17 Mar 2010 17:14
Use the Hour function to get the hour and group by the DateValue (strip off
the time) and the Hour.

Group By DateValue(DateField), Hour(DateField)


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Calif_Mike wrote:
> I have water quality data that is stored at 15 minute intervals. I would
> like to query it as an hourly average. Date and time stored together as
> mm/dd/yyyy hh:mm. Water quality is stored as "SiteName_EC".
>
> The query wisard will develop daily, monthly and yearly but not hourly
> queries.
>
> Thanks,
> Mike
 |  Next  |  Last
Pages: 1 2 3
Prev: id is not an index in this table
Next: linking tables from different Access templates?