Search results

hello all, I am using MS Access 97. I am trying to work out a query to extract the employee ratings based on certain matches... i have attached a text explaining the structure and the type of results I am trying to get... Please...If you could take time out to check this....it wud be great...

hello all, how do i keep a log of all the changes made to an access tables . And also if possible , by which user... Please do help...I m really new to this... Thank you

hello all, How does one keep log of what are the changes made to the access database in terms of the updates, appends etc.. please do help.. Thank you

great.. But once i create the views, how do i apply these views to a table of valid users in the database. I am sorry , I am really new to this...

hi all, how do i create view based on a condition. For example my database consists of a Employee table *Token ID Name AGE Location Division. Now the users of this table would be employees from different divisions. And i want to create a view for each division for records only belonging...

Good to point out that... But i was trying to point out that mistake to Blue, that you can have what he wants...but only the method is different. And ya...identification number is the safest identifier in order to uniquely differentiate between each instance of any entity. So its better to go...

yes you can have composite primary key, used as a composite foreign key in another table.. I guess you didnt select both the fields while building the relationship in the design wizard, .. You have to select both fieldnames within the primary key and also within the table using this primary key...

Oops its pretty easy.. Sorry for wasting your time..

Hello all, Multiple selects are not possible in Access.. I have a employee table who are categorized based on their division etc... Division is a seperate table which enlists all the divisions and is linked to employee table by relationship table called Designation. EMPLOYEE *TokenID...

gr8 u totally echo my mindset.... I guess i was too pressurised to get into their demands. After all its the user interface they would care about....And in the future it would be much easier to upgrade the database , if i keep it simple. Thanx for all the replies..

yes .I thought if that too. But the company wants a seperate table for the ex-employees . I guess to avoid complication and also to lock the ex-employee table from further updation. Any more suggestions?

hello all Consider i have an employee database. And i want to keep a track and analyze all the training programs every employee has attended from the day he joined ( for both working and resigned employees). The analysis part is based on division-wise, level-wise, year-wise, location-wise...

thanx for the Info mate.... That definitely gave me some sense... :)

yes.. i cliked the copy records button.. i also tried to run the query. but it shows its updating 0 rows..

thnx mate.. But the update doesnt seem to work... the query runs , but doesnt update anything.... is there particular process to follow? Sorry for the trouble

helo all, I have two tables I want to copy all the contents of column in tableA to coumn in tableB. How do i update it using queries.. please help

hello all, Is there any provision to copy and overwrite a particular portion of data from excel worksheets into Access table based on the primary key match. I am using MS office 97.

replicate column helo all, I have two tables I want to copy all the contentc of column in tableA to coumn in tableB. Both the columns are primary key of respective tables. . One more doubt-- Can i have primary key of two tables with same name... Example: Table A...

hello all, One simple question .... Hows rollback done? Till what limit can it be done? And do the capapbility change for different versions U dnt have to guess....im a newbie :o

hi, Im using MS access97 as a database. I would be using simple SQL to get data from the tables using ASP. But I also need to create graphs dynamically from data from the resultset, Ive heard of a software called SQL+D which makes use of SQL queries in ASP to build charts dynamically. Does...