Interesting Question

  • Thread starter Thread starter Zane
  • Start date Start date
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
 
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.
 
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
 
You need to use the OR not the AND condition in your
query. Look at your query in Design view and you'll see
that your expression under each column says ...give
me 'data' and 'date'... instead of 'date' or 'date'.

-----Original Message-----
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



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
Click to expand...


.
Click to expand...
 
Back
Top