query dates

[Guest]

I have two fields, one called OrdDate and another ShippedDate. I want to
retrieve data from date ordered to 10 days after the ship date.

=[OrdDAte] in the criteria field under OrdDate

<=[ShippedDate] in the criteria field under ShippedDate

I tried <=[ShippedDate]+10 but it don't work.

Thanks, for anyones help.

 

[Marshall Barton]

I have two fields, one called OrdDate and another ShippedDate. I want to
retrieve data from date ordered to 10 days after the ship date.

=[OrdDAte] in the criteria field under OrdDate

<=[ShippedDate] in the criteria field under ShippedDate

I tried <=[ShippedDate]+10 but it don't work.

Sorry but, that doesn't make much sense. OrdDate is
certainly going to be >=OrdDate and ShippedDate will
always be <=ShippedDate

You must(?) have some other date field that you want to
check??

Or maybe you want to check against the current date?

Whatever field/value it is, the criteria would look like:

=OrdDate And <=ShippedDate + 10

Or
Between OrdDate And <=ShippedDate + 10

Technically, you should use the DateAdd function instead of
using + 10:

 

[Guest]

Thanks Marsh,

I really appreciate you taking the time to help me out .

Fly Boy5

I have two fields, one called OrdDate and another ShippedDate. I want to
retrieve data from date ordered to 10 days after the ship date.

=[OrdDAte] in the criteria field under OrdDate

<=[ShippedDate] in the criteria field under ShippedDate

I tried <=[ShippedDate]+10 but it don't work.

Sorry but, that doesn't make much sense. OrdDate is
certainly going to be >=OrdDate and ShippedDate will
always be <=ShippedDate

You must(?) have some other date field that you want to
check??

Or maybe you want to check against the current date?

Whatever field/value it is, the criteria would look like:
>=OrdDate And <=ShippedDate + 10
Or
Between OrdDate And <=ShippedDate + 10

Technically, you should use the DateAdd function instead of
using + 10:
>=OrdDate And <=DateAdd("d", 10, ShippedDate)