Recent content by PureCoffee

  1. P

    Combine two Fields to One with Multiple Records

    OH I get it!!! O.k. makes sense. Wow that looks good. I will try it and let you know. /PureCoffee
  2. P

    Combine two Fields to One with Multiple Records

    I know some VBA. It doesn't scare me at any rate..:D. PureCoffee
  3. P

    Combine two Fields to One with Multiple Records

    Currently the Table is like this: Email(this is field1) Email_2(this is field2) purecoffee@gmail.com purecoffee@yahoo.com Here is what I would like to do: Email purecoffee@gmail.com purecoffee@yahoo.com Forget about all the other stuff that will be added...
  4. P

    Table Set up

    I think what you want is to do a query that selects all records from the smaller tables to create a new "all together" table which in essence would replace the old table with the new data from the smaller tables... ?
  5. P

    Table Set up

    Hi, To Clarify: 1) one large excel sheet containing ALL tables which means ALL field names from ALL tables match each other? 2) Not sure what you mean break it down. Do you want to normalize the data? /Purecoffee
  6. P

    Combine two Fields to One with Multiple Records

    Yes, this is correct. Thank you, PureCoffee
  7. P

    Combine two Fields to One with Multiple Records

    Sorry for not clarifying! Yikes! Yes, a little more background. I am attempting to normalize a "Flat Table". As an example; Record 1 under field "Email" and "Email_2" are filled in with different email addresses. So they belong to the person and I would rather have it so there is ONE field...
  8. P

    Combine two Fields to One with Multiple Records

    I have two cases of this. One with email the other with Category. What I would like to do is take the following: Email Email_2 Record--> purecoffe@gmail.com purecoffee@purecoffee.com (tblemail) Email EmailType Subscribe (checkbox)...
See more
Back
Top Bottom