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 entire lease and the start and [...]
Answer Question
| October 12, 2012 9:05 PM
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 entire lease and the start and [...]
Answer Question
| October 12, 2012 9:05 PM
Access 2003 query
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?
Answer Question
| September 19, 2012 5:52 PM
Access 2003 query
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?
Answer Question
| September 19, 2012 5:52 PM
Access 2003 query
1
