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]

Re: Unable to bring all the data

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]

Re: Unable to bring all the data


"Abedin" <abedinm@gmail. comschreef in bericht news:10c0fd70-1435-454f-b112-3f73b159585d@e5 3g2000hsa.googl egroups.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]

Re: Unable to bring all the data

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" <arracomn_o_s_p _...@planet.nlw rote:

"Abedin" <abed...@gmail. comschreef in berichtnews:10c 0fd70-1435-454f-b112-3f73b159585d@e5 3g2000hsa.googl egroups.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]

Re: Unable to bring all the data

On May 27, 10:11 am, Salad <o...@vinegar.c omwrote:

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=sdxqlrc s37c- Hide quoted text -
>
- Show quoted text -

Salad,

I did, but same thing.

[Salad]

Re: Unable to bring all the data

Abedin wrote:

On May 27, 10:11 am, Salad <o...@vinegar.c omwrote:
>

>>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.
>>
>>Cruisinghtt p://www.youtube.com/watch?v=sdxqlrc s37c- 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