How to Analyze Attributes in a Query

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

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

.

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.

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

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.

.