Search results

Hi Gemma, Thanks for your reply. I do have a form that other users access to read the data that I have input. However, what I was/am trying to achieve on this multi-organisation Table and cannot seem to is this: Every person is on the members table so that I can keep their home and work...

Thanks Ron, that is a good idea I will have a think about this. Fanflame

Many thanks for your advice Gemma-the-Husky: The members table does have a numeric ID which is the auto-created primary key... but how do I add that into the other field? At the moment it is a text box "ordinary" filed and I can only type in it... i.e. Members Table the chaps name is: John Doe...

Hi There, I wonder if you could answer this conundrum fro me please. I have a database with a number of tables 2 of which are: # Personal Members Table (with all their details and addresses and contact details) # Organisation Table (including who are members of this Org) My conundrum is...

Hi Cronk, Thanks for the explanation I have looked it up and am a little wiser now! As an ICT Manager I have to cover a lot of subjects and although not trained in programming I have to keep an eye on things overall. At the moment I have offered to help a small charity get to grips with their...

Thanks Cronk, That worked nicely but I had to put it in both halves of the Union: (what does the nz stand for?) SELECT a.Letter, a.Organisation, a.Incumbent, a.Salutation, a.Address1, a.Address2, a.Address3, a.Town, a.County, a.Postcode FROM [LEAF Member Churches] AS a WHERE nz(Letter,0)=-1...

Hi And Thanks for your reply, I inherited the database and it was messy. I have cleaned up the tables and collated most of the data but these two tables are legacy tables one for member businesses and one for non-member businesses of which there are far more. I need to do a mailshot to all...

Hi Alansidman, And thank you for your reply. I have been trying to work this out starting with just one Field from each table and then adding another field unitl I have it complete however I am still stuck. As in all things you have to be very accurate and know exactly what you want to see. I...

Hi there, I wonder if someone might assist. I have one database that I am working on and within it there are several Tables. 2 of the tables have similar information on various organisations and I need to query these 2 tables to get a simple mailing list of ALL organisation addresses and the...

Hi JDraw, Thanks for your observations. I agree that this particular field <<Address>> is not atomic in any way as it holds way too much information. However I think that it has become this way because in the past previous people like myself have found that pasting a formatted address from a...

Thanks to you both for your input. About 12 years ago I first came upon this anomaly I thought that as the full address worked when producing a mail merge I would carry on doing it. Having not worked on a large DB for some time but now taking on a new contract where the DB is quite small but...

Hi there, I have been using Access for several years but always in a basic way. I have started work on an existing Members database where the Members Addresses have been pasted in from Notepad or been imported from csv or manual entry. The ones that have been manually entered are on one line...

Hi, I have been using Access for several years but always in a basic way. I have started work on a Members database where the addresses have been pasted in from Notepad. In Notepad they look like this: 'Oakdale' 123 Expression Road Name of Town Name of County Postcode Sometimes the addresses...