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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by soojosie

  1. soojosie

    Need to separate joint names

    Hej Aceman1, I've just worked it all out, that is I think I have. I was, as ever overlooking the obvious, I separated the names by using the “&” symbol with data >>text to col this way I have all the LastNames in 2 cols LastNames1 and LastNames2 did a quick parse on the initials, then...
  2. soojosie

    Need to separate joint names

    Hej AceMan1, Yes I can now really see what a mountain of work it is. It is way, way too much for you to consider. But thanks anyway. I have worked out this DATA >> text to Col function. I have separated all the easy stuff. ID#, Type, Names, Address1 and Address2 Then I Concatenated (just...
  3. soojosie

    Need to separate joint names

    It is difficult visually with such small spaces. thanks Josie
  4. soojosie

    Need to separate joint names

    Hej Aceman1, Thanks heaps for all this sorry that last reply was a mess I've tried to improve the spaceing this time so it will be clear. Yes I do need the 6#s. I've tried to list all of the fields as I will be using them all the data needs to be separated except for address2, I need that...
  5. soojosie

    Need to separate joint names

    343671 Field Identification # YES Required 1 Field Type Wesolowski Field LastName C Z Field Initials1 7 Bounty DR Bounty Field Address2 – not to be separated 7 Bounty Drive Field Street BOUNTY Field City 6452 Field PostCode 546807 2 Hantke Tim Rob & Hantke Anne 9 Bounty DR Bounty...
  6. soojosie

    Need to separate joint names

    Hej Aceman1 i was rushing and forgot to add that I had planned to separate most of the data in the cell with "data > transfer to columns .." so it is the names and address that are causing me grief. Is 343671 a seperate cell? NO "data > transfer to columns" Is 1 NO "data > transfer to...
  7. soojosie

    Need to separate joint names

    Hej Aceman1 The maintain and the view both look great! Nearly all the data is in the one cell - yeah I know, it was a pathetic transfer, must learn if there is a better way to do it. Is 343671 a seperate cell? NO Is 1 NO Wesolowski Christopher Zdzislaw 7 Bounty DR Bounty a seperate cell...
  8. soojosie

    Need to separate joint names

    Hej Aceman1, Thanks for all your time, sorry I've not been more specific. I should have said "2nd address cannot be used" not "2nd address is unnecessary". Sorry to mess you about like this. I only need the one address per name/s in cell. Have attached a some samples. The only Addresses I...
  9. soojosie

    Need to separate joint names

    Hej AceMan1 Address All names in a single cell share the same address. For this purpose the very few that have 2, 2nd address is unnecessary. Name LastName - full, FirstName & MiddleName - Initials only. thanks Josie:)
  10. soojosie

    Need to separate joint names

    Hej The AceMan1 I have scanned data from a PDF file onto an excel Spreadsheet. This is my first experience with scanned data. In most cells there are the names of 2 people, probably a married/common law couple. Last Name, First and Middle all in a single cell, separated by an & sign. Lees...
  11. soojosie

    Need to separate joint names

    I have a list with joint names and need to 1) Separate them And then if not too difficult 2) Have Initials & Last Name in separate fields Ideally Lees Mark John & Lees Amy Kate -M J Field1, A K Field2 and Lees Field3 White Kate May - K M Field1, White Field2 Occassionally there are...
  12. soojosie

    Access mail merge SMS Text

    How would I go about using mail merge from a query in access? I am doing a simple database for a group with several hundred members that keep contact via post. Letters and recipients will change depending on situation but mainly there are 3 groups of members, but letter content varies...
  13. soojosie

    too many fields in Report headings + Count problems

    Ginger, that is brilliant thanks so much. Josie:))
  14. soojosie

    too many fields in Report headings + Count problems

    Hej GingerR, Thanks for your help, have not used a sub report before but am in the process of finding out about it. Q2 My report has several groupings Field1, Field2 etc. I am trying to get a total of the various groups. Example: need a total for New or Chair. All my totals = 5. New Chair...
  15. soojosie

    too many fields in Report headings + Count problems

    Q1 I have a report where there are 40 check box results. I only need the totals. I can't find a way to put the first lot of field headings on the top half of the report and the next lot on the bottom half. Report only has a total of 10 lines down, but is 2 landscape pages wide!!! Q 2 Have a...
See more

Part and Inventory Search

Back
Top