Search results for query: *

For sure but its mostly duct tape and chicken wire... not very elegant lol.

I just developed one from scratch

Hey All, I work in a business where we have 50 remote locations. I am seeking a pre-made utility that allows my staff to produce "Standard Operating Procedures" in Word and then to be able to go to a page, upload them, have them ripped into a pdf, the pdf then stored publicly and keywords added...

Hey All, Question: I have two tables. One has dates: WE Date 2/28/2015 3/7/2015 3/14/2015 3/21/2015 3/28/2015 4/4/2015 4/11/2015 4/18/2015 One has Sales figures: Store Dept UPC Description SUB_CATEGORY SumOfQty     SumOfCost     SumOfRetail $     WE Date 3009 BAKERY 73314723576 BUN HAMBURGER...

Thanks Duane! I think that'll work nicely.

No Sir - No primary Key. Also, I hadn't considered the tie situation. Perhaps I need to consider a different solution.

I am embarrassed to ask - I just can't figure this dumb question out. I have a table. In that table I have Store, Department, UPC, Description, Retail $. This table has like 15K records in it. I am trying to write a query that will return the top 5 (sorted descending on Retail $) for each...

Thanks Andy, I appreciate the pointers. I really haven't refined the code at all yet. As a matter of fact, that code is from a tutorial I was following to see if writing to MySQL was even feasable. I see it is, but the connection is where the hiccup is. If I can figure out a way to proceed...

...Set oConn = New ADODB.Connection oConn.Open "DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=10.144.205.198;DATABASE=store_survey;USER=****;PASSWORD=********;Option=3" End Sub Function esc(txt As String) esc = Trim(Replace(txt, "'", "\'")) End Function...

I inherited a database project that was authored by a co-worker when he left. I know the few key tables it depends on but it is polluted with a bunch of other tables/queries that may or may not be depended upon by the existing vital tables/queries needed to generate the report this project...

This one is tough. I dump a report from our payroll system to excel. In column A there will sometimes be a string that starts with 6JV/EPFPL. I need to write somethign that will search for that string and if it finds it, continue looking down the sheet in column F for the next instance it...

This is most excellent Skip. Thanks. Any way to make it so you don't have to have the linked workbook open - or maybe to make it so that when you do have it open and it links the values and you save and then re-open the values don't appear as #ref! errors (beacuse we no longer have source...

Hey all, just wondering if I can do this... My spreadsheet is set up like this: A1 = Date C1 = value from another spreadsheet for example for A1, I'll type in 10-2-2011 (formatted m-d-yyyy) and for C1 I have the following link: ='I:\Machining Business Unit\Production Output\[Business Unit...

I think I love you people.

Should be simple...? Model Num 254973 254970 TX_serial RTX_serial I want to query the above and return only numeric? Any ideas? Thanks,

So close... can I have the query only return values where the Diff does not equal 00:00:00 and can I have the query not just focus on 48 and 51 but instead look at the day and return anywhere where the PartID changes from anything to something else?

Occasionally but not likely and probably not necessary to count for. What is more likely to happen is 48 will change to 51 and then change to 53 or 45 etc later in the day. It's pretty arbitrary.

Sample of data: PartID BatchSer DateTime ISEPart 48 38487 1/8/07 7:57 AM 233960 48 38488 1/8/07 8:14 AM 233960 48 38489 1/8/07 8:16 AM 233960 48 38490 1/8/07 8:18 AM 233960 48 38491 1/8/07 8:20 AM 233960 51 24128 1/8/07 3:57 PM 826014 51 24129 1/8/07...

pretend data 1, data 2, data 3 etc are date stamps. Can I sort on date stamps first oldest to newest in this query and then select from that sorted data the row before and the row of the change of c1?

You mean how they're sorted? If so, can I build that into the query so have the query sort the data first and then perform the query? I cannot control how the data is sorted.