Search results for query: *

Thank you so much for the replies! It works the way I want it to be. Thank you again. :-)

Hi! I need help with regards to Sum()function. I want to get the sum of an amount of a particular field which falls from a date range (example: monthtodate, yeartodate etc.). How do I do it? I have to place it in detail's section. sample data: Productname Date Amount brandA...

Hello! Thank you very much for the replies. I'll definitely try it.

I try the formula that you had given but it generate an error: "A Date time is required here." I always have a problem regarding the DateAdd function. Is there an alternative way to do this? Thanks

Hi! I have a problem extracting the right data where the date range will be the last year previous month of the current month. Example 1: My date is: 2/10/2003 I want to get all the data from 1/1/2002 to 1/31/2002 and not LastYearMTD. Example 2: My date is : 12/31/2002 I want to see all the...

Hi! How do you program in VB 6 an automatic shutdown of a computer running in windows xp as its operating system? thank you very much for the help.

Hi Ken! Thanks for respond in my inquiry. The integration method I'm using is by OCX (crystal32.ocx) and my report connects to the data by ODBC. I'll appreciate very much for your help about this problem of mine. Thank you very much.

Thank you very much to all those who help me with this problem. It is finally solved. Again, my deepest gratitude.

Hi! I am in the middle of debugging a visual basic program where the Database it's using is an MS ACCESS with a password. It has no problem with the add,edit,delete and other basic functions except with the printing of record where whenever it is click it generate an error. I tried taking off...

Hi there! I'm just wondering how are you going to call a report that is made from crystal report 8 from visual basic 6? I'd been using Crystal Report 4.6 and it has an .ocx that can be added in it's toolbox. However, I can't seem to find an .ocx for Crystal Report 8 that can be added in my...

Thanks Jim! I'm going to apply it at once. Again, thank you very much.

Hi! I tried the code but it generate an error: "A number is required here" which points to the total variable. How can I solve this problem? I really appreciate the help. Thanks.

Naith, Thanks. I'll try it right away.

Hi! I'm having problem with the grand total in crystal report 4.6. My problem lies in the grand total of a specific date range. It suppose to show the grand total of the said date range example between May to June and not the whole year. What am I suppose to do to see the total only of that...

Hi! Can anyone help me in how to declare or make a parameter in crystal report 4.6? Thank you very much.