easy question new to access

[sjackson1234]

Hi,

A basic question i am running a query to export to excel

I have three separate fields in one table , for some reason the date fields have been split DATE, MONTH ,YEAR. How do i merge these fields to display DD/MM/YYYY.

Many Thanks

 

[llkhoutx]

format(cdate([MM] & "/" & [DD] & "/" & [YY]),"MM/DD/YYYY")

 

[khawar]

You can also use

format(dateserial([yy],[mm],[dd]),"MM/DD/YYYY")