Recent content by James_Morant

ajetrumpet, Thanks a lot, thats exactly what i was looking for. James

Thanks Zigzag. Sadly it is still not working. Is it because you cant reference to a field that has just been editted on that record? Here is my current query: SELECT Company_Addresses.CompanyAddressID, [AddressName] & " (" & [Town/City] & ")" FROM Company_Addresses WHERE...

I am designing a contact management system and have hit a bit of a wall. I am farily new to Access so please advise if I am going about this the totally wrong way. I have three tables; Contacts, Companies, Company_Addresses Contacts: ContactID (P) CompanyID OfficeName Companies: CompanyID (P)...

I am designing a contact management system and have hit a bit of a wall. I am farily new to Access so please advise if I am going about this the totally wrong way. I have three tables; Contacts, Companies, Company_Addresses Contacts: ContactID (P) CompanyID OfficeName Companies: CompanyID (P)...