Number Field in Business Contact Manager linked to Access form

[themurf]

I am linking my "Business Contact Manager" BCM data to my MS Access database
using a query. the problem is that the sort is very slow. I assume that the
slowness is that the BCM database makes no number fields available to me from
which to link to the "master" field in my Access database. I have searched
and can find no way to change the field type in the BCM to number. I added ad
"User Defined Field" to the BCM in number format but when I link to the BCM
database that field is not abailable to me to use. Does anyone know how I can
get access to the field I created or how to change the field type for an
existing field in BCM? any help along this line will be deedply appreciated.
Jim

 

[Jerry Whittle]

I doubt that the data type of the field makes much difference in the sorting
speed. Text, if properly set up, should also work find.

I doubt if you will be able to convert the field in the BCM table to a
number. If text, it probably has text in that field already.

Where are you doing the sorting? In the query?

You talk abou a "master" field in your database. Is this field the primary
key for the table?

Show us the SQL of the query that you are using. Open the query in design
view. Next go to View, SQL View and copy and past it here. Information on
primary keys and relationships would be a nice touch too.