I have a field called Delivery Date and one called Hire Period I need to add them together to produce a field called collection date. I can do this in a form, but I think that I need to be able to do it in a table. My ultimate aim is to be able to produce a filter which selects all the records which have a specific Delivery Date or a specific Collection Date. Maybe I need to be able to select records with an instance of a specific date in any field. But how?
Many thanks in advance.