Problem using filter when merging from Excel

T

Tom

I'm trying to filter records from an Excel file to a Word document label. It will filter properly using "equal to" for numeric values. Will not filter if using "Less than or equal to" and a numeric value.
An example:
Field name: "Over all compliance"
"less than or equal to"
"80%"
No data appears.

Anyone have a solution to this?
 
G

Graham Mayor

If this is Word 2002/3, see the Excel section at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

The first thing to do is to see what the merge field is actually returning,
without the calculation. You will probably find that the field from Excel
which reads 80% when translated into Word reads 0.80000000000000004
This will tend to make a nonsense of your calculation. You therefore need
something like
{IF{=ROUND({Mergefield Fieldname},1)} <= .8 "True" "False"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail [email protected]
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Top