Hi - I have set up a simple database to collect meter readings from users, this works ok but to improve it further I would like to restrict entry between 2 dates i.e. 15th and 19th of any given the month ( readings are then submitted on 20th).
I have done a search but can't find anything, would appreciate any help.
Also, is there a way of restricting input to once a month to avoid users duplicating readings, this would have to be for a number of venues. I have set up a form so users can check the readings history for their site and I have a sub form on the entry form which also displays the readings history but even these aren't a 100% guarantee.
Thanks
RussG
I have done a search but can't find anything, would appreciate any help.
Also, is there a way of restricting input to once a month to avoid users duplicating readings, this would have to be for a number of venues. I have set up a form so users can check the readings history for their site and I have a sub form on the entry form which also displays the readings history but even these aren't a 100% guarantee.
Thanks
RussG
