Search results

Hey, I am sorry for confusing with my explanations. Let me try to make it clear. Query: qryschedule Field: "Coulmn One" - Comes from a table Field: "Counter" - Manually added in Query Design I have a query "qrySchedule", which has a column "Column One", which comes from a table. when I run...

Hi gurus, I am having a tough time with the Running Total as well. Running total is actually summing up the values from the first to the current record. But what I want is very different thing. Every time a column value repeats, I need to add a counter for that occurrence. See my example...

thanks Very much! I will Running Total. And yes I want to use it in a query. Since there is not Countif function in Access, I thought I will have to call a VBA code in the query for this.

Hi gurus, I have a query where I need to incrementally count the repetition of column values and add that value in a new column. Example: "Column One" and "RepeatCounter" are fields in a query. Column One Repeat Counter Value 1 1 Value 2 1 Value 3 1 Value 1 2 Value 1 3 Value 3 2 I want to...

Hi, I am a new member! I am an SAP learning consultant and need to use Access for training scheduling and data management. I am a novice in Access and could use a lot a help here. Regards, Rajeev Mohan