Hi,
Apparently I'm a newbie here and I am also developing a program of my own from scratch so I hope all you experts would go easy on me. Anyway, I'm using VB6 for developing the program, A database created from MS-ACCESS using a DAO connection, Crystal Report 8.5 for designing the report.

In one of my tables(SALES) there's a list of figures and DATES(mm/dd/yy). I was able to generate daily sales reports because I only have to input the specific date under the .SelectionFormula in VB.

code:
.SelectionFormula = "{Sales.DateGenerated} = #" & DTPicker1.Value & "#"

The code on top is part of the code where I'm using the CRYSTAL REPORT control.

Now the biggest problem is that I can't figure out how to filter the dates so that I could get a Monthly Report on a desired Month.

Can someone please help me out of my dilemma? I am desperately in need of help. I am hoping to get a reply as soon as possible.