=format([dte], "ww yyyy", 7, 1)

[umair434]

Try >= and <=

Also, try converting to Integer on all three sides.

HAVING (((CInt(DatePart("ww",[dte],7,1)))>=CInt([forms]![filter]![weekfrom]) And (CInt(DatePart("ww",[dte],7,1)))<=CInt([forms]![filter]![weekto])));


this worked! thank you )

 

[vbaInet]

Good job!

But instead of CInt() use Val(). It will throw an error if it enounters Null, but Val() can handle Null.

 

[umair434]

got it! thanks again. I cannot believe how much I have learnt in 3 months solely because of you guys and this forum. Cheers

 

[vbaInet]

Very soon you will become an expert and I will be seeking your advice

Happy developing!

 

[umair434]

I hope soo too would lovee to help others!