Recent content by mountainview

I've got so far, created the append query, but how do you set the criteria to make sure the ID link bring the correct data in to the right contact? Thanks

Many thanks, I'll give that a try :-)

I've simplified the structure a bit, but I'm still missing something here :-( I have my "contacts" table from which I export the contacts ID I have my "activity" table which is a one to many relationship with contacts (contacts 1, activity many) What I'm trying to do is import in to the...

I've looked up the update query function, but it says it can't be used to create new records? is this correct. Effectively the records I'm wanting to bring back in the the notes field are new. I used to use Lotus approach, and with that I could do a conditional import of a new record, by say...

I have a customer database with consists of tables for: Customer Contacts Notes I have created all the link and the one to many relationships. I have a field in the contacts table called key words, which i populate with particular products that the individual may be interested in e.g. cars...

Many thanks for the fast reply, I'll take a look at the linked tables and see what I can do...... I may be back :-) Thanks Paul

I have a customer database which has a main form/table for customer addresses etc. then a sub form/table for contacts within each company. I have created and export excel file, which contains the main customer data, and individual contact names to allow me to create a mail shot list targeted...

Hi from the UK Moving over to Access after using Lotus Approach and Open Office base for a while. I've not used Access for a LONG time, so I hope some of you will kind enough to help me through the transition:) Paul