microsoft works database filtering

[John]

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.

 

[Malke]

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

 

[AlexB]

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/scripts/ShowCode.asp?txtCodeId=423&lngWId=5
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=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]

alright, thanks Malke!

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

 

[John]

...got it, thanks a lot AlexB!

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/scripts/ShowCode.asp?txtCodeId=423&lngWId=5
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=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.