[quote=“molona, post:9, topic:187441, full:true”]Also, it looks like you’re using three tables but you have only created one relationship: table b with itself.
[/quote]
he/she is obviously cutting and pasting from somewhere else (edit: and it isn’t here at sitepoint, see Help finding the total income from a booking for a given hotel date - #14 by molona), and hasn’t answered my question (i would’ve pointed out how the error message relates to the query, to teach him/her how to debug)
but when i get no cooperation, and instead guesswork, i sense a student hard up against a deadline with no real interest in learning…
… and that’s when i bail