Nelson Bile
Registered User.
- Local time
- Today, 16:26
- Joined
- Apr 30, 2003
- Messages
- 12
Hi,
I am confuse selete a date
In a Form I wrote two Text to select date bewteen two dates. They are Text557 and Text563
In the Query I wrote in the Field the following:
Date1: Month([ItemU].[Date]) & "/" & Year([ItemU].[Date])
with the following Criteria:
Between [Form]![MainUsedItems].[Text557].[Value] And [Form]![MainUsedItems].[Text563].[Value]
When I write,for example, on Text557 the date 01/2003 and
on Text563 the date 04/2003
Why I get the data of year 2002 beside correct data for year 2003?. How I can eliminate other years different from Text557 and Text563 ?
Regards,
Nelson
I am confuse selete a date
In a Form I wrote two Text to select date bewteen two dates. They are Text557 and Text563
In the Query I wrote in the Field the following:
Date1: Month([ItemU].[Date]) & "/" & Year([ItemU].[Date])
with the following Criteria:
Between [Form]![MainUsedItems].[Text557].[Value] And [Form]![MainUsedItems].[Text563].[Value]
When I write,for example, on Text557 the date 01/2003 and
on Text563 the date 04/2003
Why I get the data of year 2002 beside correct data for year 2003?. How I can eliminate other years different from Text557 and Text563 ?
Regards,
Nelson
