trinisunset
asked on
Crystal Reports include two books
Why can't I do this to look for people who should be under 2 books. "CARDIOPW" is one book and I want to see if anyone else is in the other books. I did test so I know I should get at least a test person but I get nothing.
{BOOK.ABBREV} = "DIOPW" and
{BOOK.ABBREV} in ["DIO", "DIOH", "DIOMI", "DIOR", "DIOSM", "DIOWR", "DIOWS"] and
{APPT.DATE} in DateTime (2012, 01, 01, 00, 00, 00) to DateTime (2012, 04, 01, 00, 00, 00)
{BOOK.ABBREV} = "DIOPW" and
{BOOK.ABBREV} in ["DIO", "DIOH", "DIOMI", "DIOR", "DIOSM", "DIOWR", "DIOWS"] and
{APPT.DATE} in DateTime (2012, 01, 01, 00, 00, 00) to DateTime (2012, 04, 01, 00, 00, 00)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't get it. Somebody can't be it 2 list at the same time (and)! It has to be DIOPW OR something else!
can you show sample data and the expected results?
can you show sample data and the expected results?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I got a "neglected question" email. I almost missed the zone too.
James
James
can you show sample data and the expected results?
ASKER
James, Sorry "CARDIOPW" is another name for "DIOPW" sorry for the mix up. I will try what mlmcc suggested and let you know if it works. Thank you for the suggestions.
ASKER
They have to belong to the mandatory book of DIOPW and I would like to find out if any of them also belong to this list ["DIO", "DIOH", "DIOMI", "DIOR", "DIOSM", "DIOWR", "DIOWS"]
I added in a test person so I know, at least, I should pull that test person up but I don't get anything.