Afternoon all, this is a follow up from an earlier post, which I am still struggling with.
I have 2 tables which have no common fields, which I need to combine into Query1, from which I can build forms etc. I can't find a way of making Query1 updateable, so I can add [passed on] dates and also change the value in [valid for]
I have attached a paired down db. To open the shift key needs to be held down as this is a result of the format of the original db.
Any assistance very welcome
I have 2 tables which have no common fields, which I need to combine into Query1, from which I can build forms etc. I can't find a way of making Query1 updateable, so I can add [passed on] dates and also change the value in [valid for]
I have attached a paired down db. To open the shift key needs to be held down as this is a result of the format of the original db.
Any assistance very welcome