I have primary created reports in access but I am attempting to switch over to crystal. I am having an issue figuring out how to implement multiple conditions on one field.
Example
{ML.ML_LOCATION} in ["FACSUPPLY", "HFACSUPPLY", "MAINSUPPLY", "MBSUPPLY"]
but then I also need to pull anything that is in ML.ML.LOCATION that is between A-14-01-A to A-14-01-F and between A-12-01-A to A-12-06-F
I cant seem to figure out how to get that all to work together? I tried
{ML.ML_LOCATION} in ["FACSUPPLY", "HFACSUPPLY", "MAINSUPPLY", "MBSUPPLY"] and
{ML.ML_LOCATION} in "A-14-01-A" to "A-14-01-F" and
{ML.ML_LOCATION} in "A-12-01-A" to "A-12-06-F"
but that did not seem to work properly. Any suggestions?
2- Does CR supports BETWEEN?
Open in new window