Search results

sorry to resurrect this, but i have an additional question. if we sort the data above by Scode then by Status and then use the First command to select the necessary date, it doesn't work. but why? l

i think this is the perfect thread for you - http://www.access-programmers.co.uk/forums/showthread.php?t=161816&highlight=slow it's a fun read.. good luck, l

i occasionally use + instead of = when i type in simple numeric formulas (e.g. +123/12) because + can be found in the number pad section of the keyboard, whereas the = sign is in a different section. minor convenience.. US keyboard. l

what exact formula are you using? i agree that lookup with 'false' should do it. something like - =VLOOKUP(VALUE,RANGE,COLUMN#,FALSE) l

the 3rd query whipped out the answer in about 12 endless seconds.. l

Namliam, i tried your 3-stage suggestion, and it worked, thanks. one question - do i have to run those 3 queries separately, or there is a way to combine them so i can run the whole thing in one shot? ByteMyzer, i tried your indexing suggestion, but for now am getting big fat blank for the...

i am purely an end-user of this database, all i see is an Access local version on my machine. so, i am not sure what type it is - SQL, Access, etc. i am more of an Excel user, i just use Access to pull data which usually end up in Excel. i'll ask the Information dept.. 1 - if 'linked table'...

Namliam, completely forgot to thank you, sorry! well, thank you. top 2, part 2: left for a day, came back in the morning - still running. at about noon, it finished. 23 hours to output about 6500 rows! and then i still had to use Excel to arrange the output.. i could have copy-pasted...

i am running a query to produce top 2 dates in each "prop id" category (see SQL below). the progress bar hasn't moved even a fraction of a millimeter while i was out to lunch. is it normal? how slow can it go?! the dbase is only about 47000 records strong. l SELECT S.[prop id], S.date FROM...

for edifying purposes, could you please post the SQL code of your query. thanks, l

ok, i think there is a problem - when you show blanks instead of zeros (through Excel Options), the ZEROS ARE STILL THERE, they are just hidden. like their font is white. my apologies. i projected this feature from pivot tables, i guess, where it works just fine.. this is for Excel 2007, btw...

another possibility - in the excel options there is a check to show zeros as zeros. if you uncheck it, there will be blanks instead. which will solve your problem - but at the expense of those zeros.. l

sure.. filter by category, i.e. select one in cell G2 (for example 'large'). now if you want to filter by sub-category, in cell G3, you still see all the possible sub-categories. i'd like to see only two - 'big' and 'huge'. this is a very simplified example, in reality i am doing this with...

thanks. i probably didn't explain myself clearly, but i actually want the opposite, sort of. let me give an example - in excel 2007 - i have 'category' and 'sub-category' variables which i use as my filter (big filter, above the table with all the data). i select 'small' in my category filter...

in excel 2007 - - bring your variable to the 'values' section of the 'pivot table field list' one more time (sum of QT2?); - go into this variable and choose 'show value as' as '% of total', instead of 'normal'; - hide the columns that show the percentages for 2007 and 2008; - hope that this...

is it possible? i have a few variables in my pivot table report filter. i'd like to narrow down the report by using one (or more) of the variables. can i make the other variable filters then show ONLY the choices pertaining to remaining, filtered data? thanks, l. excel 2007.

don't know if you HAVE to do it programmatically, but if not, there is a check-box in the options (or maybe 'veiw', or 'advanced', etc, depending on the version) that gives you an option to show or not to show zeros on a worksheet, including pivot tables.. l

here it is. ** sample ** - make sure you quality test it if you opt to use it. assuming no more than 5-course meals. l

my vba is very limited, but i know how to do it with formulas, if that helps. it's a bit bulky. basic idea would be, somewhere to the right or on another sheet or on the sheet where you have the master table of Cal Pro Carbs values, to - look for comas using FIND, e.g. FIND(",",$A1)...

it's WORD WRAP ! darn word wrap slows everything to a halt! what an utter nuisance.. i would have never guessed... but - it's not that simple - looks like it does it only in conjunction with automatic row height. still under investigation.. in the meantime - BEWARE of WORD WRAP ! l