Search results for query: *

I have the following code on the tab of an excel worksheet. Sub change_cell_color(ByVal Target As Range) Dim icolor As Integer Worksheets("sheet1").Activate areaCount = Selection.Rows.Count If areaCount = 1 Then If Not Intersect(Target, Range("C2:AH85")) Is Nothing Then Select...

Hello! I have two very similar tables. T1 (only has today's data) with an index on time field T2 (exactly like T1 but with historical data) no index Is there a way with hints to utilize the time index from T1 on T2? Forgive me if this is very simple, just trying to get a grasp of what's...

Hello! I'm fairly new to Crystal Enterprise 10. This wierd thing is happening to me. I have created several folders with copies of reports in them all. In all but 1 folder, I'm able to schedule reports to be emailed out (excel format) with no issues. In this one particular folder...

I was wondering if there is anyway to query the database to find out what CCTs have a comment on them? I'm thinking it will have something to do with the cctwit table, in particular the image field with a long raw datatype, correct? Thanks in advance!

I copied a table in Access,added _bak to the name, made changes to it, and then renamed the original _bak1, and renamed my modified copy to the original. Now when I'm trying to add a new record from a form, I get a message, "You cannot add or change a record because a related record is required...

I created a macro in Excel 2002 that some offsite users are trying to use in Excel 2000. I do not have access to Excel 2000 to re-create this macro. Can someone help me. They are receiving the following error: run-time error '448': Named argument not found Debugging brings them to the...

I have over 20 jobs where step one is a DTS package to create an excel spreadsheet with query results. The 2nd step is to email out that spreadsheet to people outside my organization. This process has been working great for over a month. As of yesterday, the email step doesn't work. In the...

a query would be written this way... SELECT (SELECT Code FROM Location AS A WHERE A.ID = Location.Parent) AS typecode, (select CODE from type where Location.type=type.ID) as tCode,dbo.OrderRecommendation.Amount...

I have several DTS packages scheduled to generate an excel spreadsheet and email them to various individuals. They work just great. However, now I'm getting requests to "format" the spreadsheets prior to emailing. I think I can add a step to the job to "format" the spreadsheet prior to...

I have a query that gives me a list of dates (3 columns, id, from date, and to date). I want to incorporate this query result using between in the where clause. Is this possible? i.e. Query results id from to 1 1/1/05 1/3/05 2 1/2/05 1/5/05 etc... I want to select...

I have the following I want create a macro that finds the word "total" in a specific column and inserts a page break immediately after that cell. Can this be done? Thanks in advance.

TB1 id m t w th f 1 0 1 0 1 0 2 1 0 1 0 1 3 0 2 0 0 2 4 2 0 2 0 2 Shipments made on days where <> 0, so id 1 gets shipments on Tuesdays and Thursdays, ids 2 & 4 on Mondays, Wednesdays, & Fridays, and id 3 on Tuesdays &...

but it's all I have to work with... in this table the fields correlate to days of the week... tb1 id m t w th f 1 0 1 0 1 0 2 1 0 1 0 1 3 0 2 0 0 2 4 2 0 2 0 2 tb2 id date in out 1 03/21/2005 0 6 2 03/21/2005 10 5 3 03/21/2005 0 10 4 03/21/2005 30 2 1 03/22/2005 15 6 2 03/22/2005 0 3 3...

With sql plus, I can use the command BREAK ON DEPTNO SKIP PAGE to give me a page break on each change in deptno. Is there something similar in sql server? Sorry if this is basic stuff, I'm still learning. Thanks in advance.

TB1 id date fbal fsales 1 02/13/2005 38 0 1 02/14/2005 42 -16 1 02/15/2005 34 -8 1 02/16/2005 48 -10 1 02/17/2005 35 -13 1 02/18/2005 37 -21 1 02/19/2005 43 -13 2 02/13/2005 32 0 2 02/14/2005 29 -3 2 02/15/2005 28 -1 2 02/16/2005 50 -6 2 02/17/2005 43 -7 2 02/18/2005 27 -16 2 02/19/2005...

I have two main tables... TB1 (Days of week, Mon, Tue, Wed, Thu, Fri, Sat... datatype tinyint) name m t w th f s a 1 0 1 0 1 0 b 0 1 0 1 0 0 c 2 0 2 0 2 0 d 0 0 2 0 0 2 e 1 0 0 0 0 1 TB2 name date amt a 02/16/2005 10 b 02/16/2005 9 c 02/16/2005 11 d 02/16/2005 12 e 02/16/2005 8 I...

i have a field with datatype float. I want to display the values of this field as money (with commas every three digits to the left of the decimal point, and no digits to the right of the decimal point; for example, 3,510 i've tried CONVERT ( money, bal,1) but I get 3510.0000. Even 3,510.00...

I'm having one heck of a time with "case" "grouping" and "cube". The problem is I really don't know how to utilize these to get the result I want. i have following "ugly" statement select c.name,b.name, e.date, sum(e.bal) from table1 a, table1 b, table1 c, table2 d, table3 e, table3 f...

My table looks like tb1 id m t w th f s 1 1 0 0 1 0 0 2 0 1 0 0 1 0 3 1 0 1 0 1 0 I'm trying to get a result set to look like id Day 1 Monday 1 Thursday 2 Tuesday 2 Friday 3 Monday 3 Wednesday 3 Friday I'm using the following: select id, case WHEN m <> 0...

I have the following 3 tables. TB1 id name date balance 1 TEST 02/09/2005 100 TB2 id orderdate orderamount 1 02/10/2005 10 1 02/12/2005 140 TB3 id saledate saleamount 1 02/10/2005 10 1 02/11/2005 20 1 02/12/2005 30 1 02/13/2005 40 My select is: select id, sum(balance)...