Unanswered: Retrieving data based on multiple field values
I've struggled with this for several hours, so it must be easy. A prod in the right direction would be much appreciated.
I'm trying to design a simple database in Access 2003 to manage garden allotments. I have a table of Holders (name, address, etc. plus two fields called Status and Residency), a table of Plots (site, plot number, plot size) and a table of Prices. I've successfully linked Holders to Plots and now I want to calculate the annual rental for each plot. The rental is dependent on plot size but also the plot Holder's Status and Residency as per the Price table below:
I remember trying to explain to the first guy training me in development that he can't simply tell me to go look it up in the documentation because I have no idea what I'm looking for. I likened it to trying to learn intermediate German from a textbook... written in German. Problem being the learner doesn't know ANY german, so that textbook is a bit on the useless side until they acquire a decent working vocabulary.