rio
Registered User.
- Local time
- Today, 18:04
- Joined
- Jun 3, 2008
- Messages
- 124
I make a query like this:
SELECT Table1.Date, Table1.Place, Table1.Person, "I meet " & [Person] & " at " & [Place] & " on " & [Date] AS Story
FROM Table1;
for the date it come out with 2/11/2009 format... how to change it to 11/Feb/2009.
Please... help me.
I'm also attach the database.
SELECT Table1.Date, Table1.Place, Table1.Person, "I meet " & [Person] & " at " & [Place] & " on " & [Date] AS Story
FROM Table1;
for the date it come out with 2/11/2009 format... how to change it to 11/Feb/2009.
Please... help me.
I'm also attach the database.