Search results for query: *

Well, I've figured out a very awful way to do it. But I'd prefer something a little more... "professional"? I used the select expert on the email field. Starts with "A-Z" in capitals, "a-z" in lowercase, and 0-9. Pretty sure you can't start an email address with special characters. At least I...

Hello Tek-Tips members! I have googled all morning and cannot find an answer for this. A couple things regarding suppressing DUPLICATES, but not sure how to apply that to my situation. So here's what we have. I've created a report that is grouped by company name. In the details section it...

Just in case someone else comes along and is looking for an answer in this post to a similar issue... I wanted to comment and say that the original formula COSpringsGuy sent ended up working correctly. The problem was, I had old Selection Criteria set in Select Expert. Here is the code...

My database structure? I apologize for being so daft or "newbish" but I'm not sure what you're asking. Do you want to know the database type? Or how the tables are structured and what the linking is like? I'm not extremely technical and have been teaching myself Crystal over the course of...

Thanks for the help CoSprings... I had a feeling this was going to be the golden ticket. Unfortunately, it didn't work to filter out the companies that placed orders outside of 06-08. It just shows orders/companies placed within those dates, even if they ordered last year or what have you. I...

I have an issue that I believe I may be over thinking. It seems like it should be so simple. Here's the deal. We have a filing cabinet of customer files that is packed to the brim. We want to thin it out a bit. So I wanted to utilize Crystal Reports to determine which accounts are no longer...