I manage a few properties that need occasional cleanings. Each property can have a few different types of cleanings (full, half, 1 room,...) and the price for each of these services is different for each property.
So I have a main table with the property name (tblProperties), then a second table with the cleaning types and costs for each property (tblCleaningCosts) and finally a third table with the cleaning actually done (tblCleaningsDone).
In order to prepare an invoice, I need a query that brings up the property name (it is a parameter), the date of the cleaning, the cleaning type, and the cost for that cleaning.
This all sounds simple enough, but the query results are not what I expect.
In the files attached you can see the data in tblCleaningCosts, the data in tblCleaningsDone, the query in design mode and the results of the query. These results came out after selecting "Es Tir" as a parameter.
What I expected was to see two records, showing two cleanings at "Es Tir" with the dates that they were done and the cost but instead I get a bunch of repeated results that makes no sense to me.
Is this a table relationship issue? What am I doing wrong?
mafhobb
So I have a main table with the property name (tblProperties), then a second table with the cleaning types and costs for each property (tblCleaningCosts) and finally a third table with the cleaning actually done (tblCleaningsDone).
In order to prepare an invoice, I need a query that brings up the property name (it is a parameter), the date of the cleaning, the cleaning type, and the cost for that cleaning.
This all sounds simple enough, but the query results are not what I expect.
In the files attached you can see the data in tblCleaningCosts, the data in tblCleaningsDone, the query in design mode and the results of the query. These results came out after selecting "Es Tir" as a parameter.
What I expected was to see two records, showing two cleanings at "Es Tir" with the dates that they were done and the cost but instead I get a bunch of repeated results that makes no sense to me.
Is this a table relationship issue? What am I doing wrong?
mafhobb