1
  • 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:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following