Search results for query: *

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

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

It is difficult visually with such small spaces. thanks Josie

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

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

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

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

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

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:)

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

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

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

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

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

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

Am doing a simple database where there are a no. of check boxes 1-20, each person can select several on each visit. I would like to run a report from a query that can add up how many/who ticked 1, 2, 3 and/or 4, so I have a total for 1, 2 etc, these will be per date blocks. The “who” is not...

Hej Bob, Would like a count of A, B etc thanks

Can't remember and can't work out how to run a query that will count no. of check boxes ticked. Am doing a simple database where there are a no. of possibilities, each person can select several. I then want to run a report from a query that can tell how many people were involved and how...

thanks so much for all the help I received, sorry about confusing start. As a very recent ex-student I have so much to learn and having a site like this to check out is a great help to the nerves. Thank you [thumbsup2]

Can someone explain to me what has happened to my question about drop down list boxes? I wanted to know how to get the 2nd list box to be populated depending on selection from the 1st list box. e.g. if flowers were to be selected in the first list box then the second would show flower varieties...