Format query field as fraction

[Matthew]

I have a field in a query that I would like to display as a fraction. i.e.,
display .5 as 1/2.

Also, I would like to enclude this field in an expression in the query.

Matthew

 

[Cheryl Fischer]

See Arvin Meyer's response in the following Google thread:

http://tinyurl.com/2w5hx

 

[Matthew]

Cool.

Next question: how do I call a VBA function from a query to format the data?

Matthew

 

[Cheryl Fischer]

You would create a Calculated Field by inserting the following in the first
row of an empty query column in the query designer:

CalcField: MyFunction([MyField])

Of course, change the calculated field name, function name and field name to
correspond with your needs.

 

[Matthew]

That worked perfectly.

When I try to access the datasource through ODBC, I get this error:
Undefined function 'FractionIt' in expression.

Any ideas?

Matthew

 

[Cheryl Fischer]

What datasource are you trying to access with ODBC? An Access database?

 

[Matthew]

Sorry about the ambiguity.

I only have one database. It is the one with the fractional field.

I am accessing the database with ColdFusion through ODBC. In case you don't
know, ColdFusion is kind of like ASP.

Matthew

 

[Cheryl Fischer]

Since the function works just fine locally and across a LAN, you may need to
ask in one of the Macromedia or other forums dealing with Cold Fusion. But
do check back here later; it is possible that someone else responding in
this newsgroup will know the answer.

 

[Matthew]

OK. Thanks for sticking with me

I am happy with the progress that was made. I will check with the
ColdFusion folks.

Matthew

 

[Matthew]

Check this out.
http://support.microsoft.com/?kbid=166113

Apparently it is "by design".

Any thoughts about a way around it?

Matthew

 

[Cheryl Fischer]

All of the products that this article refers to are versions of Microsoft
C++. You're not going to make me refer you to a C++ newsgroup, are you?
<smile>