Birthday List

I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional information) I collect customers' dogs' names and birthdays (up to 4 dogs per customer). Each month I would like to mail customers birthday cards/promos based on their pet's birthday.

My problem is that my report criteria is quite lengthy. I have to set each "Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to

06/30/1997" etc. Then I have to do the same multiple entries for 3 more "Birthday" fields.

Is there a way to just use a Filter of only the Month Range without a specific year? That way I could simply generate a list of all dogs in month of June without regard of 1998,1999..etc. Any help would be great. Thanks

Reply to
Steve
Loading thread data ...

What report are you starting from?

You can customize the report to include a filterable column that is based on the Month DATEPART (DATEPART is a SQL function).

Glenn Adams Tiber Creek C> I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional

Reply to
Glenn Adams [MVP - Retail Mgmt]

Thanks Glenn for your response. I am using the standard labels list in Crystal reports. How exactly would you customize that report.

Also, do you have any suggestions regarding a primer for SQL (books website, etc.)

Thanks again.

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Steve

Sorry, I don't do Crystal. You can edit the reports, but I believe that you need a copy of the Crystal software (Version 8) to do it.

SQL Server Books Online at msdn.microsoft.com is a great resource for SQL Server...

Glenn Adams Tiber Creek C> Thanks Glenn for your response. I am using the standard labels list in

Reply to
Glenn Adams [MVP - Retail Mgmt]

We can do this custom report for you. Please contact us if you are interested.

Jamieson Gill

formatting link

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP03.phx.gbl...

Reply to
j

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.