microsoft works database filtering

I'm learning how to use my database in Microsoft Works Task Launcher. I've
made a mock database with "date" and "amount" fields with records entered.
When I "create and apply a new filter" example: "field name" I down arrow to
the "amount" then I enter a "comparison" , with "ends with" and then "compare
to", the number "0". After this I "apply filter" but, the results shows "no
records match criteria..." when in fact under the field "amount" I have two
records the filter could find and both end with .00 dollar amounts. What's
goin' on? I'm using Windows Vista Home Premium.

John wrote:
> I'm learning how to use my database in Microsoft Works Task Launcher. I've
> made a mock database with "date" and "amount" fields with records entered.
> When I "create and apply a new filter" example: "field name" I down arrow to
> the "amount" then I enter a "comparison" , with "ends with" and then "compare
> to", the number "0". After this I "apply filter" but, the results shows "no
> records match criteria..." when in fact under the field "amount" I have two
> records the filter could find and both end with .00 dollar amounts. What's
> goin' on? I'm using Windows Vista Home Premium.

While you may get an answer in this newsgroup (which is for the Vista
operating system) from someone who knows Works (not me, sorry), you'll
have a much better chance of getting help from a Works expert if you
post in the Works newsgroup.

microsoft.public.works.win


Malke
--
Elephant Boy Computers
www.elephantboycomputers.com
"Don't Panic!"
MS-MVP

I am not familiar with this part of Works. But there are a few general
considerations I can recommend.

All filters use some sort of SQL language, perhaps implicitly. You may not
know that but the internals do it for you. There are numerous tutorials on
Trans-SQL in your case it is the SELECT command that you are trying to
implement. if you read those you will understand how filters work.

This is a good site: Sql in Simple English (part one and two):
http://www.planet-source-code.com/vb...d=423&lngWId=5
http://www.planet-source-code.com/vb...d=462&lngWId=5

I am not quite sure but it seems from your description that you do not quite
grasp how filters work. To apply a filter you have to give it a range of
values for instance: from 0 to 15 or something like this. It may be just one
value 3 to 3 but it is still a range. You cannot filter by the field name.
If you want to get all records you have to set your range from the minimum
allowable value to the maximum allowable value.

"John" <> wrote in message
news:1298E035-92C1-4243-930F-...
> I'm learning how to use my database in Microsoft Works Task Launcher.
> I've
> made a mock database with "date" and "amount" fields with records entered.
> When I "create and apply a new filter" example: "field name" I down arrow
> to
> the "amount" then I enter a "comparison" , with "ends with" and then
> "compare
> to", the number "0". After this I "apply filter" but, the results shows
> "no
> records match criteria..." when in fact under the field "amount" I have
> two
> records the filter could find and both end with .00 dollar amounts.
> What's
> goin' on? I'm using Windows Vista Home Premium.

alright, thanks Malke!

"Malke" wrote:

> John wrote:
> > I'm learning how to use my database in Microsoft Works Task Launcher. I've
> > made a mock database with "date" and "amount" fields with records entered.
> > When I "create and apply a new filter" example: "field name" I down arrow to
> > the "amount" then I enter a "comparison" , with "ends with" and then "compare
> > to", the number "0". After this I "apply filter" but, the results shows "no
> > records match criteria..." when in fact under the field "amount" I have two
> > records the filter could find and both end with .00 dollar amounts. What's
> > goin' on? I'm using Windows Vista Home Premium.
>
> While you may get an answer in this newsgroup (which is for the Vista
> operating system) from someone who knows Works (not me, sorry), you'll
> have a much better chance of getting help from a Works expert if you
> post in the Works newsgroup.
>
> microsoft.public.works.win
>
>
> Malke
> --
> Elephant Boy Computers
> www.elephantboycomputers.com
> "Don't Panic!"
> MS-MVP
>

...got it, thanks a lot AlexB!

"AlexB" wrote:

> I am not familiar with this part of Works. But there are a few general
> considerations I can recommend.
>
> All filters use some sort of SQL language, perhaps implicitly. You may not
> know that but the internals do it for you. There are numerous tutorials on
> Trans-SQL in your case it is the SELECT command that you are trying to
> implement. if you read those you will understand how filters work.
>
> This is a good site: Sql in Simple English (part one and two):
> http://www.planet-source-code.com/vb...d=423&lngWId=5
> http://www.planet-source-code.com/vb...d=462&lngWId=5
>
> I am not quite sure but it seems from your description that you do not quite
> grasp how filters work. To apply a filter you have to give it a range of
> values for instance: from 0 to 15 or something like this. It may be just one
> value 3 to 3 but it is still a range. You cannot filter by the field name.
> If you want to get all records you have to set your range from the minimum
> allowable value to the maximum allowable value.
>
> "John" <> wrote in message
> news:1298E035-92C1-4243-930F-...
> > I'm learning how to use my database in Microsoft Works Task Launcher.
> > I've
> > made a mock database with "date" and "amount" fields with records entered.
> > When I "create and apply a new filter" example: "field name" I down arrow
> > to
> > the "amount" then I enter a "comparison" , with "ends with" and then
> > "compare
> > to", the number "0". After this I "apply filter" but, the results shows
> > "no
> > records match criteria..." when in fact under the field "amount" I have
> > two
> > records the filter could find and both end with .00 dollar amounts.
> > What's
> > goin' on? I'm using Windows Vista Home Premium.
>
>