Search results

hm, strange.. i'd think it should work regardless of the values.. maybe you can attach a jpeg example, like you did in the first post, i'll take a look on monday (unless somebody answers earlier).. l

i think you just need to subtract max from min of your right axis, and then divide that number by the number of intervals on your left axis. 6600/12=550. then use 550 as your major unit on the right axis. i work(ed) in government / market research, i am good at manipulating graphs.. good...

works like a charm! thanks so much Brian.. this is just great, i wasn't even sure it was possible.. magic.. l

hi. is it possible to identify the bold portion of the text in excel (2007)? i have quite a few pages of the survey somebody did in Word, with the answer highlighted in yellow (don't ask). if i copy-paste these Word pages into excel, the highlighted answers become bold. so i have single cells...

hi. i finally finished - with the help of the forum's own great pbaldy - the query that i was going to use as the data feed for my Excel 2007 pivot table. everything seemed to be working initially - i insert the pivot table, find my query in the 'External Connection...' dialog, the "Reading...

no, it's not for a report, it's for Excel pivot table(s), so i think i am stuck with this design. which in my case is not too bad if the variables involved are indexed, i tested before.. thanks again, l

not sure how to do this exactly, but i just got an answer to my question, which i think could be helpful for your task. see here - http://www.access-programmers.co.uk/forums/showthread.php?t=208834 good luck, l

worked like a charm! the second one, since Prop ID is text indeed, and also with '>' instead of '<' since the latest dates should be labeled with '1', second latest - '2', etc. thanks Paul, this is so great.. now i just need to figure out what's actually going on in this DCount statement, and...

thanks Paul. i still can't wrap my mind around this DCount business. just not enough brain cells / connections, looks like.. so the criteria for 'Date' could be - In (SELECT Top 3 date FROM InspectionMainSm as t WHERE t.[Prop ID]=InspectionMainSm.[Prop ID] ORDER BY t.[Prop ID], t.date DESC)...

i was trying to make this work - SELECT InspectionMainSm.[Prop ID], InspectionMainSm.Date, DCount("[date]","InspectionMainSm","[date] <= " & [date]) AS [Counter] FROM InspectionMainSm ORDER BY InspectionMainSm.[Prop ID], InspectionMainSm.Date DESC; tried to make it actually count, instead of...

hi. tried to figure this out on my own (using the DCount function), but sadly in vain. say i have a table with two fields, Prop and DateInsp (property and date when it was inspected). i'd like to write a query that will produce the following output - Prop DateInsp Cntr Prop1 3/24/11...

Brian, i am so sorry i was mia for a while - just got too busy, excuses excuses.. and i feel double-guilty now - the macro works, without me doing much - i copy-pasted some pieces of code back and forth after reading this just now, and it clicked. not sure what the problem was either, i...

i am sorry, i didn't mean to use the reserved word, i just put it here because it is a meaningful name for this variable. in actuality, i used something like "wdth", or "wd" as that variable name, so the code is wd = WorksheetFunction.CountA(Range("1:1")) Selection.Subtotal GroupBy:=2...

hi. i am using the following static Subtotal function in my macro - Selection.Subtotal GroupBy:=2, Function:=xlCount, TotalList:=Array(6), _ Replace:=True, PageBreaks:=True, SummaryBelowData:=True i tried to make that "6" dynamic, but surprisingly got an error message. the code i...

looks like you need to do it through Group Policy Console - http://technet.microsoft.com/en-us/library/cc179057%28office.12%29.aspx i couldn't find it on my comp at work, so assume will need to contact admin person.. l

maybe try using negative numbers? e.g. using -1 for rows will send you one left.. here is useful simple explanation of Offset - http://blog.contextures.com/archives/2010/01/20/something-fishy-using-the-excel-offset-function/ l

i feel like i am nagging at this point, but i still can't figure out this form. Big Pat, your form from the 'attendances' database is perfect, it's exactly how i want it to look. but it doesn't change the dates in the rows when you change it up top, and it doesn't append the new attendance...

i would assume downloading in .csv and copy-pasting into your master excel sheet would be the minimal hassle. l

did you figure it out? if not, maybe post an excel worksheet, or a picture of one, showing exactly what you want to happen in the end. it's a bit hard to understand with all the columns misaligned..

perhaps i am not understanding - can't you just copy-paste one to the bottom of the other? 25x1000 is not big. l