Show negative values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I need to design a query that only shows the values that are negative. Is
this possible?
 
I have tried <0 with my one table and have gotten no results also with the
field type as number but I was able to find the negitive values with this in
the criteria

Like "-*"

HTH
 
default105 said:
I have tried <0 with my one table and have gotten no results also
with the field type as number but I was able to find the negitive
values with this in the criteria

Like "-*"

HTH
Click to expand...

Is it possible that the filed with the "numbers" in it is a text field?
If it is a text field and for some reason you don't want to change it
(likely you should) then how consistent are the negative "numbers" That is,
is the first character always a "-" or a "(" and that character never
appears in any other records in that table as the first character?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching Negative and Positive Values 20
Labels of X-as interfering with negative line 1
Reallocate array cells value from positive to negative 0
Negative scanner suggestions 4
Negative Number - Brackets instead of negative signs 3
Change values to negative amounts? 3
Excel VBA to match positive and negative transactions 3
Table Design 1

Back
Top