Format Expression Builder result

D

Davey224

Hi All,

Been scratching my head over this and hope someone can help?

I can show the date field of a table in a custom format, however when I
use this field in a query it does not inherit the format.

e.g. I want to show 03/08/2003 as 030803, if I use ddmmyy in the table
it all works fine, but using the expression builder and the expression

"Expr1: Day([Date]) & Month([Date]) & Year([Date])"

I get 382003.

Is there a function than can make each part of the expression two
characters in length? I have tried a few functions but keep failing :-(

Thanks in advance for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get unique values in expression builder 0
Looking for Dmax function in Expression Builder 7
Using Styles In An Outline 0
"Compile error in table level validation expression " after format 0
TABLES IN EXPRESSION BUILDER 3
Having Expression Builder troubles - HELP!!!!!!!! 3
Expression Builder 4
Access Expression builder is missing fields 1

Top