By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,482 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

make one field in a query with two diffrent formats

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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') ".
Nov 12 '05 #2

P: n/a
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 ] *************


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.