Find a value between two fields using IF statement in query

[mous]

I've searched through the forums to no avail.

I have two seperate fields representing start and end week numbers. (Access 2000)

e.g.

Field 1, Field 2
1, 12
1, 43
13, 30
30, 53

Can I have an IIF statement that can tell whether e.g. wk 13 is between these two values, if yes then 1 else 0.

Regards
Dawn

 

[Mile-O]

SELECT Format("ww", [DateField]) AS WeekNo
FROM MyTable
WHERE Format("ww", [DateField]) Between [Enter Start Week Number] And [Enter End Week Number];

 

[KenHigg]

Are you going to hard code 'e.g. wk 13 ' into the query. If not, where will this value come from?

kh