Concatonate date with text URGENT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field which today will display 25/04/2004 . I have another field containing text eg 'hello' I want to create a concatenated field which holds for this row 'Apr 04 hello' I can concatenate ok but it says ' 25/04/2004 hello' and that is not the format wante

Please help urgently
 
I am not an expert like many here but if you can get the
date format ok in the query by itself, you can combine the
date and Hello in a report text box. If this is not for a
report, then someone more qualified than me will have to
help.

Mike
-----Original Message-----
I have a date field which today will display 25/04/2004 .
Click to expand...
I have another field containing text eg 'hello' I want to
create a concatenated field which holds for this row 'Apr
04 hello' I can concatenate ok but it says ' 25/04/2004
hello' and that is not the format wanted
 
Martyn

Have you looked into the Format() function in Access HELP? It sounds like
you could use something like "mmm dd" as a format before concatenating with
"string".
 
Yep tried that ,but format only changes it on the fly so to speak When you then concat back with the text it brings back the value actualy held in the fiel

ta anyway
 
SELECT ([Netting Date] & (" NETTING")) AS Comment, Statements.[Netting Date
FROM Statement
GROUP BY ([Netting Date] & (" NETTING")), Statements.[Netting Date ]

I want it to show 'Apr 04 Netting' not ' 25/04/2004 Netting ' If you just format the netting date field it will not work There must be a way of doing this but it is not in format help files
 
Back
Top