Search results

Hey, hey, hey!.... it looks like it works... thanks mate!

Hehe... thanks. Yes, the values are chronological. I will give it a try. I am also working on something. I will update this topic. Think is that after this, the query will be moved to a SQL or PLSQL environment and there the fun part begins

Thanks Rabbie, think though my situation it's a little bit more complex... I'm still struggling with it so if anyone has some more tips... I gladly listen.

Hi guys, Do you guys think this can be solved in one query? I have 1 table: | Name | Start Date | Value ---------------------------- | A | D1 | V1 | A | D2 | | A | D3 | | A | D5 | V3...

I am such a dumbass :D A simple select works! sorry for stupid topic

Hello all, My dilemma is at it fallows Let's say we have 2 tables: Persons | Months ........A |Jan ........B |Feb ........C |Mar ...........|Apr ..................... ...........|Dec I am trying to get something like, in one selection: ....A | Jan ....A | Feb ....A...

Nevermind... stupid ideea... Still open to suggestions

You are preaty much right... except this scenario, there will never be just one person with the vba I got stocked to 122253 (like you said)... if I have more then 2 values, well I'm in deep s***. thanks for the perspective I was kinda blinded by the duplicates and I missed the other...

Yeah... I was afraid of that... I think I am gonna just do the sorting and grouping and then in vb I will check the duplicates and perform the swich. Guess I have to brush my dusty VB knowlege... Thanks a lot guys!

You kinda nailed it :). The data should be grouped by category. No, value shouldn't change of course... The line's integrity must be kept. Also the descending order should be kept for the non duplicate values. I may even get 3 times, 4 times the same person in a row. Tricky! I eddited my...

@DCrake: yes i want all the values; the mdf I sent it was just simplified @namliam: I'm sorry about your sister in law... just read about it... terrible; @All: The logic it's not that weird. Let me brief about the purpose of this. It's for risk analysis. So I have a couple of people identify...

Thanks for answering... I attached a sample DB and a screenshot from a report that it's also in the DB. On the screenshot I highlighted the problem areas. What I need it's actualy for the blue cells to get between the 2 values in the red cells... I don't want to have 2 persons with the same...

Hi, Here is my situation: I have a table with 3 fields: category, person and sum. What I need it's a group on category and after that an descending sort on sum (this way I have the maximum as the first value per each category). Well you'll probably say that it's a simple select, well not...