Date Format

[Jhtexas]

When I concatenate the Date, Title, and Time field together I lose the formatting for the Date and Time fields from what was set in the table. How do I set the Date and Time format in this example? I had the date set to "mmmm dd" in the table.

SELECT [date] & " " & [Title] & " " & [time] AS [Full Title]
FROM Table1;

Thanks in advance!
Jim

 

[PHV]

Take a look at the Format function:
SELECT Format(Table1.date,"mmmm dd") & " " & [Title] & " " & Format(Table1.time,"hh:nn:ss") AS [Full Title]
FROM Table1;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jhtexas]

Thank you for your help. It worked great!

Jim