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...
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...
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.