Search results for query: *

Perfect, that's just what I needed, thanks!

Hello TekTips .. been a while. I was hoping someone could help me with this query. I just need to return only the rows boxed in green. It's basically the most recent date ONLY for each suc_pic. I think I need a subquery I just don't know how to structure it or where to structure it. Any...

You guys are ridiculously awesome. Thanks so much for the help. You both were right on. I went with the LEFT JOIN approach because I do need the last record of my survey to be returned in my result set even though it may have a NULL for duration. Here's my output... Thanks guys! I'll give...

Hi All! I'm pretty sure this is possible, although I'm having trouble getting started. If you look at my screen in the link, I want to compare the time in the record with the time in the record just after it (log_id + 1) and then do a TIMEDIFF (if such a function exists to get the number of...

Thanks Skip! Working now with one exception... it deletes the worksheet as expected, however I am getting a prompt in the screen about 'workbook contains links to other data'. Do you know how I can suppress it? Here is my code now: Option Explicit Const ForReading = 1, ForWriting = 2...

All- Having some trouble. Trying to write a VBScript that will delete a worksheet from an Excel file. Sounds simple enough but I can't get this to work. I figured I would pass the xls name as arg1 and the worksheet name as arg2. Also, I don't want to be prompted since I am going to run this...

Thanks for the reply, Ginger! I should have mentioned that I am trying to see if this can be done in a single query. Anyone got any other ideas?

Hello all! Not sure how I write my query to get the following... If you see the attached screen, you'll see that I occassionally am getting the same UPC twice because my Item Desc is slightly different (typos) so my Group By is generating 2 records. I want to use a Count (which I'm doing in...

Hello everyone! My issue: My query executes fine but is very slow. I'm trying to understand if there is another way I could structure it to be more efficient. I am using Access 2003. My query: SELECT a.InvcDte, a.CustomerId, a.ItemId, b.PkgSalesSupvId, b.DftSalesSupvId, b.PkgSalesRepId...

Happiness of course! :) thanks so much, Vragabond!

I don't understand what I'm doing wrong here. My DIVS will not display in IE or FF. Can anyone help me understand what I'm doing wrong? I recently switched my doc type to xhtml. Thanks in advance. greg ps. sorry about the cut and paste of code, no server to host this on right now...

I'm not sure if it's possible, but here is what I'm trying to do... I have t_fact_pops table which contains records of pops. In this table, I have fields Expected and Available (among others). When a pop is expected but not available, no record is created in this table. So, in this table all...

Sweet, thanks Denis.

I'm trying to convert a date stored as an INT into a DATETIME format. For example, my date is formatted as 20071231 and I want to convert it to a proper DATETIME or SMALLDATETIME. Anyone know how would I go about doing this? I searched the forum and Google'ed this, but have not had much luck...

Great, thanks tsuji. I just figured it out. I named my form on the opening page and referenced it by name. I also had to add a few .value to my code. function select_item(item) { //targetitem.value = item; //alert(item.value); if (window.opener && !window.opener.closed) {...

Hi tsuji, I really appreciate your response. I'm still learning javascript, is the above code saying: If the window that opens exists and is not closed then set the field named point_lat on the original opening page (form 0) to item? If this is true, is there any need for my other onClick...

Hello all. I need an extra set of eyes if someone is willing to have a look. 'targetitem' is null or not an object in IE when I view a page I am developing. I can't figure out why I'm getting it. The JS works fine in FF, altough visually my page needs work is FF...

Thanks, Denny.

I had to import several extremely large, comma delimited text files into my SQL Server db. I didn't notice at first, but all my fields are VarChars of size 8000! Most all of my fields do not exceed 30 in length, and I want to redefine them all as nChar of size 30. Is there an easy way to do...

Thanks for the feedback guys.