Search results

  1. G

    table field validation

    hi, instead of providing validation at the client side or in the server script.... cant i provide validation in the tables fields... I have a field named YearID, datatype text.. But I want to allow only text like this ==> e.g. 'F-00' 'F-01' Do I have to put any format property...
  2. G

    Select total cost based on division

    hello all, I have got 3 tables for employee training programs Employee TokenID (pk) Name Division Training_Program Prog_ID (pk) Cost Employee_program Serial_no TokenID (fk) Prog_ID (fk) Training programs are conducted for all divisions.Employee from two divisions can also attend...
  3. G

    display all excluding a field

    how do i display all fields in a table, excluding a aprticular field sumthing like Select * from employee ( except tokenID) please do help thank you
  4. G

    query two tables, but display fields from one table

    helo al, I have two tables Employee TokenID (PK) name location post .. ..etc Rating TokenID (PFK) FinalScore I am trying to display all the fields from Employee table where Employee.TokenID= Rating.TokenID but I only want to display the fields from the Employee Table and not from...
  5. G

    update query with rnd function

    hello all I am trying to set column values to a random number between 3 and 5 PMRating TokenID: text H1: double YearID: text UPDATE PMRating SET PMRating.H1 = (5+3-3)*Rnd()+3 This shows type mismatch error . What is the problem here.. please do help...Thank you
  6. G

    rows into columns

    I have a two tables in my database related to employee ratings Employee TokenID Division Band PMRating TokenID H1 Now this statement SELECT DISTINCT Employee.Band FROM Employee This would display me all the band levels within Employee table in each row.. Is there any way I could built a...
  7. G

    display all divisions,even if not present in criteria

    hello all, I have two tables related to employee and his ratings.... Table: Employee ----------------------- TokenID (pk) Division Post Table: PmRating ----------------------- SerialNO TokenID (FK) H1 In this organization there are 5 Posts Some division may have all 5 , some may have...
  8. G

    Query Restriction

    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...
  9. G

    Log keeping

    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
  10. G

    Keeping a log!!

    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
  11. G

    conditional view

    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...
  12. G

    multiple selects

    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...
  13. G

    structure dilema

    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...
  14. G

    replicate values

    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
  15. G

    pasting to Access

    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.
  16. G

    update column

    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...
  17. G

    Rollback

    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
  18. G

    dynamic reports

    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...
  19. G

    dynamic reports again

    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. Does anybody know where i would get that? Or can anybody suggest any other...
  20. G

    dynamic reports

    hi, Im using MS access97 as a database. i would be using simple SQL to get data from the tables. But I also need to create graphs dynamically from data from teh resultset, Ive heard of a software called SQL+D. Does anybody know where i would get that? Or can anybody suggest any other...
Back
Top Bottom