Interesting Question

Z

Zane

I have a database that contains two date fields. One is
the original release date, and the other is a modified
release date if the item needs to be pushed back. I am
trying to create a monthly report containing all items
that have either a release date or a modified release
date in that month. So far I have tried for each field
an expression like Month1:Format([Release Date],"mmmm")
then under criteria doing something like [Select]!
[Month1]. But when I do this for both of them it only
selects the entries with both dates in that month, it
doesn't include ones with different months. Any help
would be greatly appreciated. Thanks

Zane
 
L

Les

You can use the month function to get the numerical value
of the month. In criteria, you can have [enter month].
Put it in criteria row 1 for the first date, and criteria
row 2 for the second date. This will OR the logic.
 
T

Tom Ross

Zane

You really need to post your complete SQL statements for someone to help you
properly.

I suspect that you used and AND in your where clause where you should use
an OR

AND in a
 
Top