I have a database which I am making to log fertilizer and how much is kept at each location on our farm.
I have:
tbl_store_location,
tbl_fert_type,
tbl_add_fert,
tbl_remove_fert
I have the forms working well, adding and removal of the fertilizer works in two separate tables so that all records are kept and my idea was to just use a date range to compute what was in each store at any point in time but now I have got around to making the queries I'm having a mental block on how to do this, any suggestions?
Worth noting, I am currently on access 2013 and windows 8 pro 64bit, not got around to changing my profile