Recent content by UBNSLICK

I have a form created from a query/table with 18 columns. I have rearranged the combo boxes to group like info. I have to page through 2000 entries to edit data. I have also built a form I can use to add new info rows to the table. My question is can I set up a way (new form or within...

Thats It! Thanks Boss liked all is good!!!

I forgot te tell you I was in EXCEL. So countif is out of the question? does all theis go on one line? I am a newbie and need a little more put here etc if pos. Thanks

Sorry to confuse, this is what I am after. Drawing Release By Month/Year Jan-07 ___ 3 Feb-07 ___ 3 Mar-07 ___ 1 Apr-07 ___ 4 Feb-08 ___ 1 Mar-08 ___ 3 Apr-08 ___ 1 May-08 ___ 2 DRAWING TITLE ITEM TYPE RELEASED 3453465 LAYOUT NC REV 1/23/07 6456457 LAYOUT NC REV 1/23/07 M6565-3...

Sorry I need to give you more info I'm pulling info out access then going back to Excel to find how many for each month per year. Is this possible, I have tried count, countif, dcount etc. and keep getting Jan-00 or 1/1/00 depending on how I have the cell formatted.

I need number of entries by each month per year. I want the following to show in a cell as: 4 1 3 7/16/07 7/16/07 7/17/07 7/21/07 9/10/07 1/10/08 1/15/08 1/26/08 Thanks DC

Brian, That's it Thanks for the help. I was close by using (help) but could not quite get it. Have a great day!

Hello, I would like to filter out numbers not having a specific digit in a certain location. example - I want to see only the ones with (9) in the 7th digit location 2527100004 2527100006 2527109005 2527109007 2527200001 2527209005