Search results

  1. W

    How do I combine two tables in this simple way?

    Redneckgeek - Yes I see exactly what you are saying, I changed it a little but followed your thought process. Thank you so much for your help. I wrote some code to create the running count by ID and it works great. The full outer join does not work by itself, but it is needed to pick...
  2. W

    How do I combine two tables in this simple way?

    This may be more of a VBA or Report question. I have not found anyone who can figure this out. Any ideas at all would be helpful. -Colin
  3. W

    How do I combine two tables in this simple way?

    Using your exact code (and renaming the table) this is what I got from Access: Select tblA.fld1, tblA.fld2, tblB.fld3, tblB.fld4 From tblA Left Join tblB on tblA.fld1 = tblB.fld3 Union Select tblA.fld1, tblA.fld2, tblB.fld3, tblB.fld4 From tblA Right Join tblB on tblA.fld1 = tblB.fld3...
  4. W

    How do I combine two tables in this simple way?

    I am trying to combine two tables and I do not know enough about Access to even search for the solution to this (though I have spent many, many hours trying to search for it). I have included a good example of what I am trying to do (just with much more data). Basically, I want the end result...
Back
Top Bottom