• Access 2003 Query

    I have a table (tblRents)with the following fields: RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the...

    kgonzales20 pointsBadges:
  • Removing Duplicates

    I have 2 access tables. One has doctors and membership totals, the other has doctors and their addresses. When I join both in an inner join, the membership totals duplicate because of the doctors multiple addresses. Is there a way to have the membership total appear only once?

    Dash145 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.