Access SQL - combine Date and Time into one field for query
Posted on 2014-10-02
When I design a database I use datetime fields and put both date and time in the field. Someone else designed the one I'm working with and even though both fields are datetime type, one has the date and the other has the time.
VIA Access SQL only, how can I combine the two into one "field" - I've tried "DateField + TimeField" but it just prompts me for a value. I think it might be something with CAST or CONVERT if this were T-SQL...
I would think this is easy and quick... anyone have any ideas?