Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    New Jersey
    Thanked 0 Times in 0 Posts

    Historical Reporting (Access 2000)

    I am having a really difficult time running historical reports. I have a EEO report due next month which I need the following information,

    Previous Dept New Dept Previous Job Title New Job Title Name Most current promotion date Previous Salary Current Salary

    Unfortunately, I need to combine multiple tables to get the data, but, I am also getting multiple records for each table when I do this. What I would like to do is get a report that will only give me most current and previous record but in one line.

    Is this possible? I need to find a better way of doing this than manually.

    Help <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Historical Reporting (Access 2000)

    What is the relation between this question and <post#=341420>post 341420</post#>?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts