Recent content by ayla

  1. A

    Make "to" value based on "from" value

    I need help creating a query that creates a "to" value. Have this table: Manr_f, CC, SD, ED Manr_f = employee number CC = Cost Center SD = "from" date ED = should be "to" date based on SD Manr_f,CC, SD, ED 1001,1,6924,7759 1001,2,7760, 1002,1,6924,7589 1002,3,7590,7799 1002,1,7800...
  2. A

    Filter out max value, but <= today

    CC.date are stored as a string and the date conversion gives a result as a number. Could this be the problem?
  3. A

    Filter out max value, but <= today

    Main database run Oracle, but when you run a report it export 'most used' data to a personal access database. The access database is deleted everytime I run a new report. If I need data from the main database I have to link up the table to access or run SQL statments. On the main database...
  4. A

    Filter out max value, but <= today

    Can you give me a more detail description. Extracting these value is just a part of the report. I have tryed to group, then I get the valid value, but when I then continue with the report and try to group on something else, I mess the result. I tryed to run this sql statment: UPDATE...
  5. A

    Filter out max value, but <= today

    I have some problems to extract some data from a access database. The problem is that the table hold the entire history of all employees, and I need to extract only the valid value on all employees. Ex: Employee1, value1, FromDate: 16.12.2008 Employee1, value2, FromDate: 01.01.2009...
See more
Back
Top Bottom