RecordSert Problem

[tedew1]

hello,
I have a big problem with RecordSet
recodrSet dosen,t see currebt week
today is first week
when I do this :
"
STRSEL="select distinct [date] as dzien,datepart(wk,[Date]) as week from dane where datepart(wk,Date]) between '1' and '1' and year([date]) between '2006' and '2006' order by 1"

I have no result , when i change "... dateparat between '1' and '2' .... "

this show my data from this week.
When I paste this SQL to the QueryAnalyzer ewerythisng is OK
this is my source code

spr.Open STRSEL, CurrentProject.Connection

While Not spr.EOF

Data = spr!dzien
...
Wnd
spr.Close


the funiest thing is that when i Put date 51 and 52 week in 2005 ewerty thing works fine.

I have no idea why Rescordset Sees this week as Second of this year


????

bye