Recent content by usmchummer

  1. U

    A dandy of a difficult denormalization problem

    Chris, So the query worked (took hours to run) but left blanks in some instances (IE EMP 1 ACTION 1 _______ ACTION 6 ____ ACTION 10) How would you do this in a report/subreport? I only thought they could go vertically? Thanks again for your help!
  2. U

    A dandy of a difficult denormalization problem

    Dont worry about it - I will assign a temporary numeric identifier and VLOOKUP it to the actions table. Let you know how this works!!
  3. U

    A dandy of a difficult denormalization problem

    Your idea is great - only one problem, what if my employee id's are text? It breaks the qryActionNos query. Do I need to reassign them numeric ids for this exercise? Thanks!!!
  4. U

    A dandy of a difficult denormalization problem

    Thanks much! I will test it out and let you know how it works out. I truly appreciate everyone's help
  5. U

    A dandy of a difficult denormalization problem

    Lawyers. That should say it all....
  6. U

    A dandy of a difficult denormalization problem

    I will head down the road of VBA records then. I will wait a little bit to see if Stopher has any magic he can work on this, otherwise it is what it is - and I will begin the looping........ Thanks again!
  7. U

    A dandy of a difficult denormalization problem

    I am assuming use some form of electron microscope when they see how small the font is when printed. But in any case, this is what they want - so they can see the activity bridge per employee.
  8. U

    A dandy of a difficult denormalization problem

    OK, So here's a good one - I am trying to create the attached through a query or some VBA code. Is the only way to do this via VBA in excel? Or is there some sort of fancy union/query that will work? It will need to create new columns for each and every new action (if it goes past 3 in...
See more
Back
Top Bottom