Not Equal

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • dmkeith2@hotmail.com

    #1

    Not Equal

    I have a sub report that I place in another report. When I do this I
    have to specify the Child and Master IDs.

    I would like the data from the subreport to only show the personnel
    that are not equal to the same EIN (tax ID Number).

    basically I am showing associate data, ie people that have the same
    mailing address. I show the primary subjects address on the first page
    but only want subject who doesn't have the same EIN on the second.

    I have my tables setup with a main table and referential integrity on
    everything else. All my forms and reports are runing off queries on
    not the tables.

    Thanks for any help.

  • pietlinden@hotmail.com

    #2
    Re: Not Equal

    use a subselect to remove that record from your subreport datasource.

    Comment

    Working...