Criteria question

[Lyndseyd]

Hi all,

This is just a quick question, for one of my fields the users enter a number, this could me a minus or positive number. I have been asked to produce a report which shows the total of the minus number and the total of the positives. I have set up a query for the minus number and have looked at various ways to distinguish the negative number from the positive. I tried <0 but never worked. Microsoft help gave an example of a name column and sed to use Like "*w*", to show all the names that begin with w. I tried to adapt it for my numbers ie Like "*-*", but it doesnt work, without this separation i can't total up the negative and positive number seperately.

Thanks for in advance for any replys.

 

[FoFa]

If it is a numeric field, negative numbers should be detected by < 0. What is the data type of your field?

 

[Lyndseyd]

The data type is number, thats what i can't understand, i thought it would work using < and > but it doesn't

 

[Lyndseyd]

I have sorted it now, thanks for your help FoFa