EXTRACT RECORDS BASED ON A DATE FIELD

S

Samora

Hello

1st: O.S: Windows XP
2nd: Regional settings short date 23-02-2005 (Control Panel)
3rd: Access 2003


i have a table with a field named AData .

Based on that table i made a Query with a parameter where i
type the date i want to extract my records.

i have 4 records with the field AData with the value
12-02-2005( short date and dd-mm-yyyy format.

When the input parameter appears i write #12-02-2005# and
nothing appears in my query.

What am i doing wrong? I really don't understand... Do i
have to make any more configurations on my computer or in
my query or eventually on my table??

Could anyone help me???

Thanks in advance
Samora
 
D

Dan Artuso

Hi,
Try using the mm/dd/yyyy format.
It's interpeting your 12-02-2005 as December 12 2005
 
D

DebbieG

If you have a parameter window that appears, you don't have to type the #'s, just type the date.

HTH,
Debbie

|
| Hello
|
| 1st: O.S: Windows XP
| 2nd: Regional settings short date 23-02-2005 (Control Panel)
| 3rd: Access 2003
|
|
| i have a table with a field named AData .
|
| Based on that table i made a Query with a parameter where i
| type the date i want to extract my records.
|
| i have 4 records with the field AData with the value
| 12-02-2005( short date and dd-mm-yyyy format.
|
| When the input parameter appears i write #12-02-2005# and
| nothing appears in my query.
|
| What am i doing wrong? I really don't understand... Do i
| have to make any more configurations on my computer or in
| my query or eventually on my table??
|
| Could anyone help me???
|
| Thanks in advance
| Samora
|
 
Top