Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    I wrote up a quickie Access db to help analyze a dataset and produce a report. The initial query locates only those rows where a particular number is matched 3 or more times, then I re-attach the main dataset to only those that match with the numbers in the first query - essentially just filtering out those with 3 or less. anyhow, the report runs fine, and has some date info that I'd like to display in a summary section as the lowest and highest dates in the body of the report. I have run into trouble getting this to work and thought DMin/DMax would work, but I don't know if this is possible as the body of the report doesn't, to my knowledge, constitue a 'domain'.

    Any ideas?

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    Have you tried using simply Min and Max?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    I tried that in the underlying query but am getting the same value in the report.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    I'm afraid I don't understand what you want.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    problem solved... used this:
    =Min([PAYMENT_BEG_DT]) & " - " & Max([PAYMENT_BEG_DT])

    in the appropriate place on the report... Thought it was easy enough. Now to do some date diff calcs!

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max and Min on a Report (Access 2K, Win 2KPro, SQL Server 2K)

    I wanted, on a report that breaks out the data, to also display the earliest date on the table and the latest date on the table, so people can easily see the time period in which the issue I am investigating occurred, and as an added bonus, the number of months involved. I used calculated fields in the summary line of the report body. Works fine, now.

Posting Permissions

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