I have a problem.

In my access database I have two fields with DateTime. I use them for when a meeting starts and ends.

I would like to concatenate them for a report, but 09.00 ends up as 9.0 so my desired "09.00 - 10.15" ends up as "9.0 - 10.15".

Please help.

  • You need to format the number as a string. If I recall correctly, this is done with a formatting mask of #.## in Access. – Randolph West Sep 14 '16 at 7:42
  • I have tried, using a calculated field. But I keeps truncating the numbers. – Jesper Sep 14 '16 at 9:43

A pound sign in a mask suppresses zeros. Change your pound signs to 9's. Or just use Format([startdate],'Short Time') + ' - ' + Format([enddate],'Short Time')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.