We compile statistical and other data relating to our 400+ affiliates on
an Excel sheet called the Extranet. I have been trying to generate a
table showing Performance Data for Community-Based matches - this is
Column AO on the Extranet. Specifically I want to identify all agencies
that currently have 500+ Community-Based matches. I've been hitting the
Select button, putting in Extranet where it says Select Records from
Table. When I get to press Assist and go to Columns, the Columns
display as follows A, B, C etc. I select AO, then select >= for the
Operator, and then put in 500. I keep getting the message "Datatype
mismatch in expression. Syntax error. Please correct and try again."
I have typed in the full name of the column and get the same message.
This is my first post. Hope I explained the problem correctly. Any
assistance/advice will be greatly appreciated.
Kathleen C. Klee
Coordinator of Agency Development
Big Brothers Big Sisters of America
voice: 215-665-7788 fax: 215-567-0394
email: [EMAIL PROTECTED]
Big Brothers Big Sisters-Little Moments. Big Magic
