Recent content by plantj

RSX02 jiqjaq has told you no lies but I'm not sure either of us understands your requirements yet You said that given this data... co_num Item.item co_ship.Ship_date coitem.qty_shipped 10 cp-10000 2002-10-26 2 11 cp-13000 2002-10-26 4 12...

bluedragon2, sorry about the delayed response. I believe 2 tables are required because otherwise if there are no sales for a particular month there wouldn't be any output for that month. But you are correct in that all the "real" data is in the existing database.

Try advanced filter. Say you name the full list range "rngAll". On a separate sheet create a 2 row range with the first row containing the heading for the ranking (as in the main range) and under it put the "excellent" rank. Name this range, say, "rngCriteria&quot...

Prior to Excel XP you only had the option to add a background picture. You could use a pict with a flat colour to do what you wanted. Won't print though if that matters.

Every solution is ugly in Access :) This is an SQL 7 solution you could adapt (I don't have Access, sorry) create table month( i int ) go insert into month values(1) insert into month values(2) insert into month values(3) insert into month values(4) insert into month values(5) insert into...

Go Insert | Symbol You can assign your own shortcut keys

Column charts have data points running vertically whereas bar charts run horizontally. They are both histograms.

Why not just pick "Selection" from the zoom combo? As Zathras pointed out, customised interfaces cause confusion.

It's very low tech but the solution I use is to press Ctrl-S often.

Good thinking. Would this do? =ROWS(range)-COUNTBLANK(range) Or for good measure - taking out the cells with a single double quote... =ROWS(range)-COUNTBLANK(range)-COUNTIF(range,"""")

Don't give up that easy :) Curiously, it seems that COUNTBLANK counts cells containing a single quote even though ISBLANK returns false for such cells. Try this - it may give you the one liner you need... =COUNTA(a1:a10)-COUNTIF(a1:a10,"""")-COUNTBLANK(a1:a10)

Yes I have experienced this problem too Corinthia. I think the fact that the {numpages} field is not always automatically updated - especially when it appears in a header or footer. As far as I can tell you will need to select all (ctrl-A) and update fields (F9) before printing. I even added...

Does this help... If the total is in the last cell in column H on Sheet22 the following formula will return it. =OFFSET(Sheet22!$A$1,COUNTA(Sheet22!$A:$A)-1,7)

I'm surprised if even runs: Code is an ambiguous fieldname (contained in T1 and T2). This aside your left join will work as an inner join since you reference T2 in the where clause. Try something like... SELECT T1.Code, T1.Desc FROM T1 LEFT JOIN T2 ON T1.Code = T2.Code and T1.Qty > T2.Qty...

NoCoolHandle, I must say in fafrazh99's defense that (i) the careful ordering of columns can pay off by aiding the readability of the schema (ii) select * is bad practise in most situations but it can be used often by support and maintenance personnel (iii) fafrazh99 may have many tables to...