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 gkittelson 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. greyhawke

    Extra Personal Folders

    Sometimes, you have to create a new profile to get the folders to remove from the folder list. Just my two cents worth. Caron.
  2. greyhawke

    duplicated emails

    Sounds like the messages might be getting stuck in the delivery queue on the Exchange server for whatever reason. Check the queue to see if they are there. Delete them if they are. You might have to stop and start the IMC service. Hope this helps. Caron.
  3. greyhawke

    How do I combine 3 records into one in Access?

    Oakleaf - yes, that is correct. Same part number, different desc - which is actually coming from a multi-value database so it is making each line of desc from database a separate record with same part number. Neil - Thanks so much for the detailed example. I will try this and let you know how...
  4. greyhawke

    How do I combine 3 rows of same field name into one field in Access?

    If I have: Part No. Desc 1x9090 Ball bearing 1x9090 1-1/4" diameter how can I combine the two lines of desc (number of lines will vary) into one field OR how do I show the multi-lines of desc on a report and only show the part number once. Thanks. Caron.
  5. greyhawke

    How do I combine 3 records into one in Access?

    Thanks for the input. I'll pose this question to the Access forum. Have a great weekend! [bigcheeks]
  6. greyhawke

    How do I combine 3 records into one in Access?

    I feel like I'm being a little thick-headed today, but I'm going to ask anyway....[blush] If all of my desc lines are in the same column (or field-name) what tells Access which is DescLine1 vs DescLine2, etc.?
  7. greyhawke

    How do I combine 3 records into one in Access?

    Thanks for the replies. In response to the first reply from Anne, yes, the number of desc lines will vary. Maybe an example would help. Part No. Desc 1x1090 Ball Bearing 1-1/4" 1x1090 diameter I want one part number field and one desc field. I am using ODBC tables, a query to...
  8. greyhawke

    How do I combine 3 records into one in Access?

    I have extracted information from a database via ODBC. My part number ends up having 3 lines because each line of the description is in a separate record. How can I combine the description into one field instead of three?

Part and Inventory Search

Back
Top