Way to Retrieving data with date parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred's - 30 May 2007 15:55 GMT

Hi folks,

I hope that someone can help me with the following problem.
I would like to have an access report with a date parameter that
allows me to retrieve data from an access table. I've tried to add the
following date parameter in a query "Between [type beginning date] And
[Type Ending Date]" My problem is that whatever dates I put into the
date parameter, I always have the same data. It seems that the
parameter doesn't recognize the data that must be retrieved from my
access table.

Can somebody help me please.

Thanking you all,
Fred's

Reply to this Message

Jerry Whittle - 30 May 2007 16:17 GMT

A few things to check for:

1. Is the field where you have the criteria an actual date/time field or a
text field that looks like a date? It must be a date field to work properly.

2. I'm assuming that you don't actually have the double-quotes around the
criteria. Just checking!

3. While in the query design view, go up to Query, Parameters on the menu.
You should have two parameters listed exactly like the stuff between the
brackets in your criteria AND they should both be date/time Data Types.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi folks,
>
[quoted text clipped - 11 lines]
> Thanking you all,
> Fred's

Reply to this Message

Fred's - 30 May 2007 17:01 GMT

Thank you Gerry, this have solved my problem.

Fred's

On May 30, 11:17 am, Jerry Whittle
<JerryWhit...@discussions.microsoft.com> wrote:

> A few things to check for:
>
[quoted text clipped - 28 lines]
>
> - Show quoted text -

Reply to this Message