| :: How Do I Filter by comparing 2 fields? :: (4) | Post a New Message | Post a Reply |
 How Do I Filter by comparing 2 fields? | Post a Reply |
since: Feb 21, 2005
from: Hawaii
I can choose the VHSLS field from the drop down box and choose "equal to" in the next dropdown box but what do I type in the next text box?
I tried "VHSLSFIN.Status", "{{VHSLSFIN.Status}}", "[VHSLSFIN].[Status]" but none of it works =(
 Re: How Do I Filter by comparing 2 fields? | Post a Reply |
from: Washington, DC
Try using this in the relationship instead i.e.
VHSLS.Status = VHSLSFIN.Status
And select only the fields from VHSLS you want to appear on the report.
-------------------------
Ghost
| Re: How Do I Filter by comparing 2 fields? | Post a Reply |
since: Feb 3, 2006
from: United Kingdom
I have one table with 2 fields: ordertotal, ordertotalpaid and I just want to list the ones for which ordertotal <> ordertotalpaid.
I'm only using this table so I can't use the relationship at the beginning.
Any ideas?
| Re: How Do I Filter by comparing 2 fields? | Post a Reply |
from: Washington, DC
In the Add filters to your report section of the dialog wizard, instead of adding a value in the
Value text box, you will add the field name prefixed by the ! - Sign as shown in the image below:' 
-------------------------
Ghost