I have a button where it brings runs a macro which applies a filter based on the criteria on the query, 10-12pm 12-2pm etc....what i would like would be to have one button which brings back the relevant results for the filter based on the time right now?
any help appreciated
Ideally this should have been stored as time (a start Date\Time and an end Date\Time). You should store data in its correct data type. Time is not text.
Also, this is not atomic - first normal form states that the content of columns should be one single thing - you are storing a start and end time in a single column.
So it could have been simple however now you need to:
1) Parse the text and extract the start and end times
2) You then need to convert these (and your current time reading) to compatible datatypes. I would suggest Date\Time
3) Compare the start and end times with the current time.
excellent, would that be an update query of some sort? regarding the BETWEEN operator, how would the query look?
as i would need it to do something like checked the current time and see what its between