[AccessD] date query

Hello Mike, Doris and Gustav,

Mike and Doris you were right.
The fieldname Date gave me the trouble.

Gustav, sometimes i don't trust myself
to show a query that isn't working.
Because i expect that the solution is simple,
i sometimes think "what do the other members
of the group will think of such an easy question".

I am not a developer and use access for easy
working with patient data. I often don't have the time
to concentrate total on a query or code. I know this
is a bad excuse and that the best way to learn is taking
time and confront myself with my mistakes.
But time time time.

I am glad that you folks exist and help with all the access problems.

Thanks i will try to make more time.

Greetings

Pedro Janssen


----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, September 25, 2004 9:15 AM
Subject: Re: [AccessD] date query


> Hi Pedro
>
> > i have a table [tblmeasure1] and important for the query are two
> > fields:  Date and Temperature.
>
> > I am trying to get avg, min etc. etc from Temperature in certain
> > date periods (Between #...# and #....#. But i keep running into
> > errors. What is the right way to do this?
>
> This is the way. So why not show us your query?
>
> /gustav
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>