Week and Year in query 1

[checkOut]

What is the best way to restrict a period in a query.
f.e. : week 34, 2003 t/m week 3, 2004.

3 fields: dteFact, descFact, currFact.

I understand to set wk as datepart("ww";dteFact) and yr to
datepart("yyyy";dteFact) but how can I restrict the period?

Thanx in advance
Gerard

 

[Trendsetter]

If you are working with actual dates then you could use:

Between #01/10/2003# and #01\10\2004#

Or

Between Forms!frmName!startDate And Forms!frmName!endDate

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[PHV]

What about this ?
WHERE Format(dteFact, "yyyyww") Between "200334" And "200403"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[checkOut]

Thnx PHV
Nice shot! Clear, easy and working