Why cycle (all records) not work on my form I set data entry = Yes The form based on query == Query Criteria is Forms!FormName!ControlName (The ControlName is on the form) We aren't there. We don't know what query you are using. Please post the SQL-statement of your query. Regards Jeff Boyce Microsoft Office/Access MVP "a" <a@a.net> wrote in message news:uRwhikeYIHA.220@TK2MSFTNGP04.phx.gbl... > Why cycle (all records) not work on my form > > I set data entry = Yes > > The form based on query == Query Criteria is > > Forms!FormName!Co...

I want to use VBA to count the occurrences of a filename in column M, such as "myfile.xls". Problem is, each time the name appears (after the first one), it'll include a number, like "myfile(2).xls", "myfile (3).xls", and so on. Also, I can't just count occurrences of the name because it could appear as a non-filename ("myfile"), without the .xls extension, and I don't want to count that. When I have finished counting them, I want to add another instance, with a higher number than the existing ones, also in column M. I've been ...

Hi, I work for a Truancy Reduction Center. We receive referrals from over 50 schools in the district for kids who are truant. We'd like to know the number of referrals a specific school sent us during a specific month. Referral Dates are in F4:F500 and School Names are G4:G500. This is what I've been trying: =SUMPRODUCT(--(TEXT('Client Log 09-10'!f4:f500,"yyyymm")="200910"),--('Client Log 09-10'!G4:G500="pacifica")) These functions work separately, but don't seem to want to play together. I just read a suggested relat...

This formula is working but what it's doing right now is giving me a total unique count of names PER QUEUE. Sometimes agents work in two or more queues per day, so what I need it to do is give me a total unique number of names even if the same name shows up under multiple queues. Make sense? If so, does someone know how to make the formula do that? =SUMPRODUCT(((Queue_User_Routing.csv!$C$2:$C$2000="Appeal")+(Queue_User_Routing.csv!$C$2:$C$2000="Duplicate Resolution")+(Queue_User_Routing.csv!$C$2:$C$2000="Manual Determination")+(Queue_User_Routing.csv!$C$2:$...

I'm trying to count individual numbers in a pivot table, for example... I have this... A1=1 A2=1 A3=5 A4=6 A5=7 With the "=count" function I'm getting the answer "5" because there are 5 different cells with information on them, I need to get the answer "4" because I have four different numbers. I need excel to count A1 and A2 as 1 because it's the same number. Hi, there is no count distinct option in Excel Pivot tables. You can use the following formula in the spreadsheet and reference the pivot table you can use the array formula: =SUM(1/COU...

I have a table that shows all the employees that have been termed. I want to count how many different codes each manager has used in a given amount of time. ie: bob termed 10 employees using codes 2,3,5,9,12,2,5. what formula can I use to show me: two terms code 2, two term code 5 an so on for a total term of 7 employees Have a great day Your sample layout or try to count bob for reason 2 =sumproduct((a2:a22="bob")*(b2:b22=2)) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "PR Kid" <PRKid@discussions.microsoft.com> wrote in mes...

Access 2003, Windows XP Pro. SITUATION: Database has lots, which have sublots, which have items. Sublot key is a barcode number. I have a query that joins the three tables, and since a sublot can have multiple items, the sublot key can occur more than once. I want to run a query against this big query that just groups and summarizes some things, one of which is the number of sublots in a given lot. Using a straight Count fails because of the multiple occurrences of the sublot key value. Here's an attempt to show this pictorially: LOT SUBLOT ITEM A A12...

I need to determine how many Separations were processed by a particular salesperson. A | B 1 MIKE | SEPARATION 2 MIKE | LEAVE 3 SARA | SEPARATION 4 JOE | SEPARATION 5 JAMIE | LEAVE 6 MIKE | LEAVE 7 JOE | LEAVE 8 SARA | SEPARATION The only way I can think of is the COUNTIF Funtion *COUNTIF(-range,criteria-)* =COUNTIF(A1:A8,(A1:A8="MIKE")*(B1:B8="SEPARATION")) This does not work though. The results return 0 with no errors when the answer should be 1. does anyone else know of a wa...

I need to create a graph that uses 2-cycle by 3-cycle log-log graph paper. I was told that Excel can be used to do this. However, after fiddling around with it for an hour, I have been unable to figure out how to do it. Any suggestions? Charles A. Wilson - The only Excel chart type that supports log-log is the XY (Scatter) chart type. If more "fiddling around" with an XY (Scatter) chart doesn't yield results for you, post again with your problem and your version of Excel. - Mike http://www.MikeMiddleton.com "Charles A. Wilson" <Cha...

How do I use worksheet functions to count the number of fields in a database that contain a specific text string, or include specific characters within a text string ? For example : Car Price Landcruiser 40 Landrover 30 Lada 10 Rolls 90 Lada 10 Landrover 30 I would like a cell to count the number of occurrences of 'Lada' in this table, and the answer should be 2. I tried using DCOUNT but it only works on numbers. I would also (ideally) like to be able to count all the cars that start with 'La', so the answer should be 5. Is thi...

THIS IS AN MICROSOFT EXCEL QUESTION: URGENT Suppose I have two columns "A" and "B". "A" "B" Error Open Error Closed Not Error Open Error Open Error Closed ------------------ ------------------ ----- -> Represents blank rows.. How will I find Error which are open in columns 0-7 (including blank rows) Try putting this into C1 =SUMPRODUCT((A1:A65535="Error")*(B1:B65535="Open")) Hope it helps, -Bo -- Message posted from http://www.ExcelForum.com ...

I've just run the cycle RR in Project Account for the first time and have found several problems: GP is mixing up client projects on the same RR window Skips RR documents so I've lost my audit trail Doesn't start a new doc for each contract, as specified in the Cycle instruction And a few other things. Has anyone else had these problems? ...

Dear All Say there are 100 records in Column A and the records are all number ranging from 1-5. The numbers are not equally represented... for eg there are 10 "1", 20 "2", 50 "3", 5 "4" and 15 "5". Hence my question is.. is it possible to count how many "1", "2", "3" "4" and "5" and then put a corressponding rank beside the number? Fo eg. as there are 50 "3" which is the biggest out of the other numbers, its ranking is 1. So is it possible to create a macro/functio to get this rank...

I am still having problems counting blocks of 1's. A few are returning the correct values, but others are seem to be adding 1 from the previous column. The formula I'm using is.. =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) =SUMPRODUCT(--(D1:D511=1),--(D2:D512<>1)) =SUMPRODUCT(--(E1:E511=1),--(E2:E512<>1)) =SUMPRODUCT(--(F1:F511=1),--(F2:F512<>1)) =SUMPRODUCT(--(G1:G511=1),--(G2:G512<>1)) and so on. The first formula is entered in D1 =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) and so on. Col A B C D E F G H I J K L ...

Hi, I have a continous form and I sum the number of records in a text box in the footer. Control Source = Count([StockID]) This is a stock record of marine spares. Some combo boxes on the form provide filtering criteria so that sotck item details, location and number of Stock Lines (records) can be viewed. There are about 32,000 records in total and each time it runs it takes several seconds to present the result on screen. I wondered if there was a faster function or some code that could speed this up? -- John Whyte JohnW wrote: > Hi, > > I have a continous form and I sum...

ppey,I am a newbie to Access. I have a report where i am trying to get a count of the number of times "0" appears in a column. The name of the column is NumberOfResult.ThnaksGerry Gerry, You could add a calculated field to the report query such as... IsZero : IIF(NumberOfResult = 0,1,0)Then just =Sum(IsZero) in any footer. Or, in any footer... =Sum(IIF(NumberOfResult = 0,1,0))-- hthAl Campagna . Candia Computer Consulting . Candia, NH USAMicrosoft Access MVPhttp://home.comcast.net/~cccsolutions"Find a job that you love, and you'll never work a day in ...

I am trying to find the count of all the cells that have an F in one column and also have an A in another column and I'm getting an error. I hope Excel can do this with a simple formula. I don't do macros. Here's an example: 1 A F 2 B F 3 A P 4 A N/A 5 B P 6 A F Basically I am trying to determine how many "A" level requirement have Passed, how many have Failed, how many are N/A and the same for the B level requirements. I've already tallied the total Fails and Passes with ...

I use a Web query to obtain a table on a Web page. How can I know the number of rows in the result QueryTable? The current code I use is as follows: Sub Test() Dim MyStr As String MyStr = "URL;http://mySite/currentuser" With ActiveSheet.QueryTables.Add(Connection:=MyStr, _ Destination:=Range("a10")) .RowNumbers = True .WebSelectionType = xlSpecifiedTables .WebTables = "11" .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SaveData = True End...

Happy new year. I have two columns (A1:A100 and B1:B100). The first column includes the values “ON”, “OFF” and “-”. In the second column i have some dates and empty cells. I would like to apply a formula in the C100 cell, which counts the “ON” cells in A1:A100 but only if the adjacent cells aren’t empty. (That means: count all the “ON” in the Ai cells if the Bi cells have dates values). Any idea? Thank you. In C100: =SUMPRODUCT((A1:A100="ON")*(B1:B100<>"")) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechan...

I would like to have two calculations per field: an actual count and a % of row amount. For Example: Account Type New Existing Transfer Total Checking 20 10 20 50 40% 20% 40% 100% I can't seem to make the pivot table give one row in numbers and the second row in percentages. Any assistance would be greatly appreciated! Thanks, Eric ...

I was reading on a website trying to figure out what they changed in 1.3. It mentioned something about a cycle count menu. http://www.positivetechnology.com/rms_ver_1_3.htm I have 1.3 but i dont see anything about these menus... Can anyone help me find these? what is the best way to do cycle counts? ...

If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH Sunday ABCD Saturday MMM Friday ABCD Monday EFGH Monday I want report show like Saturday Sunday Monday Tuesday Wednesday Thursday Friday ABCD 3 0 1 0 0 0 0 EFGH 0 1 1 0 0 ...

Hi, I have a more comprehensive query below but don't really have the time to wait for a comprehensive answer. Could you please help me with going through a list in VBA? I have a named range and the first column has a list of countries. I want to go through this list and do an action for each country. Can you please help with how to do this? I've tried things like application.index(myrange,,1) with no luck, and don't know the appropriate way to cycle through once I have that too. I have a fuller query ('Creating multiple pivot report at run time') with...

Hi, My client has been using Business Portal 4.0 for over a month in conjunction with Dynamics GP 10.0. Recently the client has received the following error in the Event Viewer: asp.net is cycling the AppDomain Any idea of what the problem is and how it can be resolved? More detail below: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 2009/05/19 02:27:04 PM Event time (UTC): 2009/05/19 12:27:04 PM Event ID: de12506fed09447a8a8b47bd3c3a26f7 Event sequence: 2757 Event occurrence: 2 Event detail code: 0 Application information: Application domain: /...

I know this is covered but I have spend more time trying the solutions rather than find the one I really need. I have Workstations that belong to Branches and I need to count how many Workstations are in each branch. The Branches field is a Combo Box if that matters. I have 10 Branches. I need to create a summary of all the branches. IE: COB 5 IAAS 25 PGO 3 I tried =Sum(ABS([BranchShort] = "IAAS")) and get error "This expression is typed incorrectly, or it is too complex to be evaluated. A Numberic expression may contain too many complicated elements. Try si...