Recent content by churchill

thanks for all your help with this post guys. Ive managed to sort it out now. Thanks

Thanks for all your help ive solved the problem. Thanks again.

Im working for a company on part of a summer placement. I have created two databases for them, the one i am trying to add access rights to contains confidential data, headings and tables. This has been my main problem, as i know what i need to do its the explaining to others that im not very...

i cant unfortunatly as the databse is rather large and currently being used by those in the office. So i have to work around the database at the moment. If that is possible

I havent put anything in place yet. I dont know the best method of completing it. Unfortunatly i cant send anything as the data is confidential. I just need some guidence into how to complete it and the best way in doig so. Thanks

I have two tables in table one i have unique id, name and sales data, in table two i haveunique id, name and field. I want to add a filed column to the first table which imports the field specified in the second table. Each customer has a unique id which it matches on. Is this possible...

I have searched but i still dont know how i would go about adding it to the database. Sorry. Any suggestions.

yeah i agree

I dont know if this is possible, but i need to add different access rights to a database. I finish my summer placement in 2 weeks and need to set the database up so that all employees can look at the database but only one can modify it. I know how to do it in excel but i cant seem to get it to...

thank you thank you for your advice ill give it ago and see if i can egt it too work. Thanks again.

SELECT Table1.T1Field1, Table1.T1Field2, Table1.T1Field3 FROM Table1, Table2 WHERE (((Table1.T1Field1)=[Table2].[T2Field1]) AND ((Table1.T1Field2)=[Table2].[T2Field2]) AND ((Table1.T1Field3)=[Table2].[T2Field3])); I took this code off another thread, and wodnered if it would work for mine. I...

Sql the database with 19 tables is sorted thanks for your adivce guys. But im stuck with another task and wondered if you were able to help me. i have one table containg the data from two seperate spreadsheets, they contain all the same fields but what i have done is said which spreadsheet...

Huh! pardon, what does that mean. I can write java programs im just not very good at access unfortunalty. Can you help me at all. Im really stuck

SQL Queries No as each table contains the same headings but different data, and in one table would be difficult to read. The 19 tables work and displays the list i wanted it to. But i need to sort through the tables and find certians customers, or customers who could be in any 4 ,3 or 5 tables.

Hi, I have two lots of data one contains a list of everything sold and the other contains alist of everything they have thought we have sold. I need to compare the two lots of data to find those that dont have a match i.e. those which they think we have not sold. i also want to be able to...