Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Help? (A2k (9.0.3821) SR-1)

    Query Help?
    A2k (9.0.3821) SR-1

    I have the follow table:

    <pre>Type Description Code #B #H Value

    101 Single Family Private 1 1 125000
    101 Single Family Private 1 2 255000
    101 Single Family Public 1 1 175000

    104 Three and Four Family Private 1 1 275000
    104 Three and Four Family Private 1 1 375000

    105 All Other Private 1 1 325000
    105 All Other Private 1 1 455000
    105 All Other Public 1 1 575000</pre>


    What is best way to set up the query that will feed a report as follows?

    <pre> Private Public
    Type Description #B #H Value #B #H Value

    101 Single Family 2 3 380000 1 1 175000
    104 Three and Four Family 1 1 650000 0 0 0
    105 All Other 2 2 780000 1 1 575000</pre>



    Thanks, John

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Help? (A2k (9.0.3821) SR-1)

    Create a query for the public values and a query for the private values. Join the queries on the Type field in a 3rd query.
    Charlotte

Posting Permissions

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