I have a field that represents time but it is formatted as numerical and has no colons. It follows military time but midnight is minus the first two digits leaving the hour code out.
I need to be able to read this as AM and PM and have the user be able to specify the time spain.
I tried to...
All the fields in my form come from a query with the exception of one field.
That one field I want the user to be able to type anything into it (it will be a comment section). I have made an unbound field but when you type into it all the rows in that field populate with what you are typing...
I have a field that has data with text and numbers. For example:
1/123hg
45/984phl
1/456
53/54656
All data has the / in it and I want to omit only the data with the text in it.
I have tried a number of like and not like type statments but have not been able to figure out how to omit this data...