Query expression builder returns text instead of numeric
- From: B+ve <Bve@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 29 Mar 2008 11:32:01 -0700
When I build a simple expression in a querry based on two other fields, both
numeric, the result is a text/Date value. e.g., Expr1: [Value]+[Commission]
When I try to Format the field in Properties no formats are available and
the Input Mask is for Text?date.
I have even tried to force format to numeric and also used the FormatNumber
function in the expresion builder, but to no avail.
--
Be positive
.
- Follow-Ups:
- Re: Query expression builder returns text instead of numeric
- From: Allen Browne
- Re: Query expression builder returns text instead of numeric
- Prev by Date: Re: How many nulls in each field?
- Next by Date: Re: How many nulls in each field?
- Previous by thread: Union query and exclusion of data
- Next by thread: Re: Query expression builder returns text instead of numeric
- Index(es):
Relevant Pages
|
|
