Way to Retrieving data with date parameter

[Fred's]

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

 

[Guest]

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.

 

[Fred's]

Thank you Gerry, this have solved my problem.

Fred's

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

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- Hide quoted text -

- Show quoted text -