Recent content by beckwiga

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) {...