JonJCurry@Yahoo.co.uk wrote in news:1192528478.456716.149710@v23g2000prn.googlegroups.com: The work is carried out in serveal areas so I make a new database for each area........the probelm is thugh sometimes when a PDA is docked all the data from the wanted database gets put into Access but the problem is the all the data from a seperate DB also gets merged into it as well !!!!

<Caddyshack.Al@gmail.com> wrote in message news:1183075135.001085.125560@d30g2000prg.googlegroups.com... On Jun 28, 2:22 pm, "Christopher Morris" <Drac...@roadrunner.com> wrote: Novak was trying to find out why the adminstration selected someone critical of president to go to Niger. It was through Armitage that Novak learned Wilson's wife, Plame, worked at the CIA.

This was right on the money! Thanks! -- --coastal "Ron Coderre" wrote: Try this ARRAY FORMULA: =MEDIAN(IF(N392:N1491<>0,N392:N1491)) Note: For array formulas, hold down [Ctrl] and [Shift] when you press [Enter], instead of just pressing [Enter]. Does that help? *********** Regards, Ron XL2002, WinXP "coastal" wrote: I am trying

Try this ARRAY FORMULA: =MEDIAN(IF(N392:N1491<>0,N392:N1491)) Note: For array formulas, hold down [Ctrl] and [Shift] when you press [Enter], instead of just pressing [Enter]. Does that help? *********** Regards, Ron XL2002, WinXP "coastal" wrote: I am trying to calculate both an average and a median for a list of numbers. I have zeros in the list which I want to keep in

I am trying to calculate both an average and a median for a list of numbers. I have zeros in the list which I want to keep in the average calculation but need to ignore the zeros in the median calculation. Is there a way to write that formula? Right now I have: =MEDIAN(N392:N1491) I cannot simply sort by the column in question because I have serveal columns that I have to do an average