make one field in a query with two diffrent formats

[zion saal]

i wont to make a field in a select query to put two fields from a
table
into one field or control like " Expr1:[field1]&' '&[field2] "
but the problem is thet "field1" is a Currency format and field2 is a
date\time format so when i run the query its display like this " 20
1/25/04 "
but in the table is displaying field1 like this " $20.00 " and ist
lost the format in the query so what cen i do to make it in one field
and the display shoot come up with the format Currency for field1 and
then the field2 with its
onae format i wont thet the query shold show me in one field like
this:
********** [ $20.00 1/25/04 ] *************

thank for whoo ist can help me i will very Appreciate

thanks in sdvense
zi******@thejnet.com

[Steve Jorgensen]

On 27 Feb 2004 09:15:10 -0800, zi******@thejnet.com (zion saal) wrote:

i wont to make a field in a select query to put two fields from a
table
into one field or control like " Expr1:[field1]&' '&[field2] "
but the problem is thet "field1" is a Currency format and field2 is a
date\time format so when i run the query its display like this " 20
1/25/04 "
but in the table is displaying field1 like this " $20.00 " and ist
lost the format in the query so what cen i do to make it in one field
and the display shoot come up with the format Currency for field1 and
then the field2 with its
onae format i wont thet the query shold show me in one field like
this:
********** [ $20.00 1/25/04 ] *************

thank for whoo ist can help me i will very Appreciate

thanks in sdvense
zi******@thejnet.com

When you concatenate currentcy into strings, you get the plain numeric format.
Use the Format function to convert data from any built-in, scalar data type
into a desired format. In this case, use " Format([field1],'$0.00') & ' ' &
Format([field2],'m/d/yy') ".

[Mike Storr]

Within the expression for the field, use Format() on each of the fields
separately, and convert this result into a string.

Expr1: CStr(Format([field1], "Currency") & " " & Format([field2], "Short
Date"))
Mike Storr
www.veraccess.com
"zion saal" <zi******@thejnet.com> wrote in message
news:c9**************************@posting.google.c om...

onae format i wont thet the query shold show me in one field like
this:
********** [ $20.00 1/25/04 ] *************