I am trying to combine two seperate fields (time and date). I can do this by just using and "&" in between the fields in a new field but lose the ability to format as a general date/time record. Any ideas?:mad:

Don't use the & but instead use + (for date/time concatenation because technically they are numbers behind the scenes).

Can I change the format to something like this 01/01/09 14:15?

try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields

try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields

You should use n for minutes - h:n

http://downloads.btabdevelopment.com/screenshots/timeformat.png