how to format date from year month and day?

[Jeff06]

I have a table a
year month day
2005 1 1
2005 3 1
2006 5 1
I want to generate the associateed
1/1/2005
3/1/2005
5/1/2005
which funciton I can use to do that?

Jeff

 

[Rabbie]

Look up "Dateserial" in Access help

 

[boblarson]

Concatenation, but you really need to rename your fields as you currently have them as Access RESERVED words and that will only bite you.

Once you've changed it, you can build a field in a query by using:

MyDate: MyMonthField & "/" & MyDayField & "/" & MyYearField

But, you should be storing it all together as you can easily pull parts if you need them.

 

[boblarson]

And, Rabbie has another method that will also work, and that method will actually return a true date instead of string which mine will. So, you probably want to use the DateSerial one instead.