Prev: Multiple fields into one
Next: Date query allowing user to enter dates
From: SHKNBKE on 7 May 2010 10:04
Is there a function/formula that you can use in a query against a field to
return what type of attribute the field value is?

If so, can you then change that attribute just in the query output?

Thanks.

SHKNBKE

From: Jerry Whittle on 7 May 2010 11:24
What do you meand by attribute? Are you talking about the data in the field?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"SHKNBKE" wrote:

> Is there a function/formula that you can use in a query against a field to
> return what type of attribute the field value is?
>
> If so, can you then change that attribute just in the query output?
>
> Thanks.
>
> SHKNBKE
>
> .
>
From: SHKNBKE on 7 May 2010 11:41
Jerry Whittle wrote:
>What do you meand by attribute? Are you talking about the data in the field?
>> Is there a function/formula that you can use in a query against a field to
>> return what type of attribute the field value is?
>[quoted text clipped - 6 lines]
>>
>> .
Actually I belive it would be the data type.
Thanks.

From: PieterLinden via AccessMonster.com on 7 May 2010 14:29
SHKNBKE wrote:
>Is there a function/formula that you can use in a query against a field to
>return what type of attribute the field value is?
>
>If so, can you then change that attribute just in the query output?
>
>Thanks.
>
>SHKNBKE

You can try casting it... it might work (depends on the types you're trying
to cast from/to). There's a function for each destination type

CStr[ing] e.g. CStr(1) = "1"
CInt[eger] CInt("1") = 1
etc...

Is that what you were looking for?

--
Message posted via http://www.accessmonster.com

From: Jerry Whittle on 7 May 2010 15:12
You can use the TypeName function.

Select FieldName, TypeName([FieldName])
From YourTable ;

As far as changing the data type in a query, you can use things like the
CDate and Val functions to change text to dates and numbers respectively.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"SHKNBKE" wrote:

> Jerry Whittle wrote:
> >What do you meand by attribute? Are you talking about the data in the field?
> >> Is there a function/formula that you can use in a query against a field to
> >> return what type of attribute the field value is?
> >[quoted text clipped - 6 lines]
> >>
> >> .
> Actually I belive it would be the data type.
> Thanks.
>
> .
>
 | 
Pages: 1
Prev: Multiple fields into one
Next: Date query allowing user to enter dates