Querying records for the last 2 weeks

[ckpoll2]

I'm trying to build a query that will return data for the last 14 days regardless of what date the query is being run. Here's what I have under the criteria section:

Between Now() And (Now()-14)

I think that this is close to what I need, but it's not quite returning exactly what I want. How can I fix this?

Thanks,

Charlie

[ADezii]

I'm trying to build a query that will return data for the last 14 days regardless of what date the query is being run. Here's what I have under the criteria section:

Between Now() And (Now()-14)

I think that this is close to what I need, but it's not quite returning exactly what I want. How can I fix this?

Thanks,

Charlie

This should do it:
DateAdd("d",-14,Now())

[ckpoll2]

This should do it:
DateAdd("d",-14,Now())

That didn't return anything when I put it in. Any other suggestions?

[MMcCarthy]

Try this:

Between Now() And DateAdd("d", -14, Now())

Remember that Now is a full timestamp including time value. You could try replacing Now() with Date() and see if this gives a more accurate return.

Between Date() And DateAdd("d", -14, Date())

That didn't return anything when I put it in. Any other suggestions?

[PEB]

You can also try:
Between int(Now())-14 And int(Now())