Concatenate Date & Currency Fields

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

Guest

Professionals: I need to concatenate 2 fields - a currency and date. No
problem concatenating however I get something that looks like this:

10000 on 212004

I need:

$100.00 on 2/1/2004

Thanks in advance.
 
What expression are you using now? This should work:

[CurrencyField] & " on " & Format([DateField], "m/d/yyyy")

--
John Viescas, author
"Building Microsoft Access Applications" (Coming Soon!)
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
John, thank you for your suggestion. I am going to try it. I was having a
problem getting the currency to format. It just keeps coming out as 10000 for
example. I was at a loss. I had no idea what to do.

John Viescas said:
What expression are you using now? This should work:

[CurrencyField] & " on " & Format([DateField], "m/d/yyyy")

--
John Viescas, author
"Building Microsoft Access Applications" (Coming Soon!)
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
TinleyParkILGal said:
Professionals: I need to concatenate 2 fields - a currency and date. No
problem concatenating however I get something that looks like this:

10000 on 212004

I need:

$100.00 on 2/1/2004

Thanks in advance.
Click to expand...
Click to expand...
 
If it's a true Currency field, then converting it to a string by
concatenating it (&) should format it correctly. If it's some other data
type, then you'll have to manipulate it. What is the data type of the field
containing money?

--
John Viescas, author
"Building Microsoft Access Applications" (Coming Soon!)
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
TinleyParkILGal said:
John, thank you for your suggestion. I am going to try it. I was having a
problem getting the currency to format. It just keeps coming out as 10000
for
example. I was at a loss. I had no idea what to do.

John Viescas said:
What expression are you using now? This should work:

[CurrencyField] & " on " & Format([DateField], "m/d/yyyy")

--
John Viescas, author
"Building Microsoft Access Applications" (Coming Soon!)
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
TinleyParkILGal said:
Professionals: I need to concatenate 2 fields - a currency and date. No
problem concatenating however I get something that looks like this:

10000 on 212004

I need:

$100.00 on 2/1/2004

Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top