Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hammer45

    Select ALL data from query/table??

    WooHoo!! It worked great! Thanks for your help! Now I'll try the "Find Unmatched Query" to get my differences between this result set and the reference table Data Points. Thanks again.
  2. Hammer45

    Select ALL data from query/table??

    Certainly (using your example above): User1 User2 User3 User4 abc def ghi jkl mno pqr stu vwx Result desired: AllUsers abc def ghi jkl mno pgr stu vwx Does that explain it better?
  3. Hammer45

    Select ALL data from query/table??

    Ok, the "+" did not work at all and the "&" simply concatenated all the fields in each record into one record. What I need is for each field in each record of the original table to be a distinct (omit duplicates), separate record in one column. Does that make sense? I'm not sure how to...
  4. Hammer45

    Select ALL data from query/table??

    BTW, the SQL code I posted above was generated by Access - so I am wondering why it chose the "Requirements.RQ_User1, Requirements.RQ_User2..." type of statement instead of "RQ_User1, RQ_User2...." type? Things that make you go "Hmm...
  5. Hammer45

    Select ALL data from query/table??

    Thank you all for your posts - I will try them out to see which one works best for my needs. As far as normalization: you're right - the price of being an only-touch-Access-once-in-a-blue-moon kind of user (and not coming from a programming background). Nonetheless, I REALLY appreciate these...
  6. Hammer45

    Select ALL data from query/table??

    This CAN'T be that tough!!!! I have a query that looks at a table and tells me which records have data in any of 8 fields (SQL code below): SELECT Requirements.RQ_User1, Requirements.RQ_User2, Requirements.RQ_User3, Requirements.RQ_User4, Requirements.RQ_User5, Requirements.RQ_User6...

Part and Inventory Search

Back
Top