I am a new access user and I hope someone can help me with this question.I have created a table and a respective form that includes the field "Date and Time". The format I would like to use is the short date option fromat and short time option format within the same field. Is there a way to accomplish that?

Thank you

Have you considered a cross tab query...example