EXTRACT RECORDS BASED ON A DATE FIELD

  • Thread starter Thread starter Samora
  • Start date Start date
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
 
Hi,
Try using the mm/dd/yyyy format.
It's interpeting your 12-02-2005 as December 12 2005
 
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
|
 
Back
Top