Unable to bring all the data

[Abedin]

Hello,

I have a simple query that is trying to bring all the data according
to the criteria below

Not Like "0" And >"4.99"

but it is not bring it up.

What could be the problem. It is only showing up 32 records instead of
49 records.

Now here is the deal.

There data looks like this:

9.99
0
5.99
19.99

It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

Any help is appreciated.

Thanks

[Salad]

Abedin wrote:

Hello,

I have a simple query that is trying to bring all the data according
to the criteria below

Not Like "0" And >"4.99"

but it is not bring it up.

What could be the problem. It is only showing up 32 records instead of
49 records.

Now here is the deal.

There data looks like this:

9.99
0
5.99
19.99

It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

Any help is appreciated.

Thanks

You could create a calculated column to filter on instead. Let's say
the field is called Amt. You could then create a column and enter
CurAmt : CCur(Amt)
to convert the string to a currency and then your filter would be
Not Like 0 And >4.99

Of course, it might be better if the field was a currency type and then
you wouldn't have this problem.

Cruising
http://www.youtube.com/watch?v=sdxqlrcs37c

[Arno R]

"Abedin" <ab*****@gmail.comschreef in bericht news:10**********************************@e53g2000 hsa.googlegroups.com...

Hello,

I have a simple query that is trying to bring all the data according
to the criteria below

Not Like "0" And >"4.99"

but it is not bring it up.

What could be the problem. It is only showing up 32 records instead of
49 records.

Now here is the deal.

There data looks like this:

9.99
0
5.99
19.99

It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

Any help is appreciated.

Thanks

Is this Numeric data (yes) or string data (no)
So simply get rid of the double quotes

What do you mean by Not Like "0"

I guess you need as criteria only

>4.99

Arno R

[Abedin]

Arno,

What I mean by Not Like "0", beucase I have 0s there as well. And I
don't want all the zeros.

On May 27, 10:10*am, "Arno R" <[e-mail]:

"Abedin" <[e-mail] in berichtnews:10**********************************@e 53g2000hsa.googlegroups.com...

Hello,

I have a simple query that is trying to bring all the data according
to the criteria below

Not Like "0" And >"4.99"

but it is not bring it up.

What could be the problem. It is only showing up 32 records instead of
49 records.

Now here is the deal.

There data looks like this:

9.99
0
5.99
19.99

It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

Any help is appreciated.

Thanks

Is this Numeric data (yes) or string data (no)
So simply get rid of the double quotes

What do you mean by Not Like "0"

I guess you need as criteria only

4.99

Arno R- Hide quoted text -

- Show quoted text -

[Abedin]

On May 27, 10:11*am, Salad <[e-mail]:

Abedin wrote:

Hello,

I have a simple query that is trying to bring all the data according
to the criteria below

Not Like "0" And >"4.99"

but it is not bring it up.

What could be the problem. It is only showing up 32 records instead of
49 records.

Now here is the deal.

There data looks like this:

9.99
0
5.99
19.99

It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

Any help is appreciated.

Thanks

You could create a calculated column to filter on instead. *Let's say
the field is called Amt. *You could then create a column and enter
* * * * CurAmt : CCur(Amt)
to convert the string to a currency and then your filter would be
* * * * Not Like 0 And >4.99

Of course, it might be better if the field was a currency type and then
you wouldn't have this problem.

Cruisinghttp://www.youtube.com/watch?v=sdxqlrcs37c- Hide quoted text -

- Show quoted text -

Salad,

I did, but same thing.

[Salad]

Abedin wrote:

On May 27, 10:11 am, Salad <[e-mail]:

>>Abedin wrote:

>>>Hello,

>>>I have a simple query that is trying to bring all the data according
to the criteria below

>>>Not Like "0" And >"4.99"

>>>but it is not bring it up.

>>>What could be the problem. It is only showing up 32 records instead of
49 records.

>>>Now here is the deal.

>>>There data looks like this:

>>>9.99
0
5.99
19.99

>>>It is only picking up single digit before decimal. And it is not
picking up double digit before decimal.

>>>Any help is appreciated.

>>>Thanks

You could create a calculated column to filter on instead. Let's say
the field is called Amt. You could then create a column and enter
CurAmt : CCur(Amt)
to convert the string to a currency and then your filter would be
Not Like 0 And >4.99

Of course, it might be better if the field was a currency type and then
you wouldn't have this problem.

Cruisinghttp://www.youtube.com/watch?v=sdxqlrcs37c- Hide quoted text -

- Show quoted text -

Salad,

I did, but same thing.

Did you put the new filter
Not Like 0 And >4.99
under the CCur column?

How about simply

>4.99

under the CCur column?

If you did and it's still incorrect, place a checkmark in the Show box
row for the CCur, remove the filter (temporarily), and verify the results.

Horo'a i te Here
http://www.youtube.com/watch?v=VFzYPTqpXG0