Select where field display is a %

[wish24bone]

Hi,
I have a table with a number field that is set to display as a %.. (ie.. 100 displays as 100.00% when the column is selected)..

I want to not see where the value = 100..

my query
----------
SELECT [SmartAdvisor Infrastructure Request List].[% Complete]
FROM [SmartAdvisor Infrastructure Request List]
WHERE ((([SmartAdvisor Infrastructure Request List].[% Complete])<>100));

This still shows record that are 100.00%.. even though the field is a number, because the display is %, how can I get around this?
Thank you in advance

 

[Taruz]

Hi..

Try this..:

SELECT [SmartAdvisor Infrastructure Request List].[% Complete]
FROM [SmartAdvisor Infrastructure Request List]
WHERE ((([SmartAdvisor Infrastructure Request List].[% Complete])<>1));

for 7% ..:

......uest List].[% Complete])<>7/100

 

[wish24bone]

Thank you, that worked