Recent content by dtfrancis15

This is the error I get - swears blind the "-" is at fault: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: "-"]' /datawhsesample/Service/Contracts/InActive/teamcontracts.asp, line 45

dtDate is todays date strDate is todays date in a different format dtThen is the date x months previous strDateThen is the date x months previous in different format. dtThen = DateAdd("m", "-" & Request.Form("Months"), dtNow) This reports an error because of...

I pass the variable "Months" from page 1 to 2, and then using the following set dtDate as today and dtThen as the date 3, 6, 12 or 18 months prior as set by Months. How do I set this as a useable variable for the following reports?? How do I use "Months" in place of -2 in...

I have a report to look at any contracts expired in our system, but I want to view this as contracts expired three months, 6 months or 12 months prior to the current date. The date is pulled as the current date - and the 3 or 6 or 12 months is selected on the previous screen in a drop down box...

I have the post codes for all our customers in the database, but I only want the letters at the start of each one - ie IP99 4HH will be IP, G1 4JJ will be G. As you can see, some are two letters long, some are only one. How do I get only the letters from the postcode?

Thanks to both of you. I am now processing a number of internet based reports for our salesman based on top 10 customers in various markets.

I want to be able to list the top 10 customers by turnover. How would I use the TOP command in the following statement? SELECT Sum(NetValue) as NetValue, CustomerName FROM InvoicedOrders WHERE Month = May AND Year = 2001