View

[bigspank]

I have a view, in it I am filtering blank lines, I need some method of counting and displaying the number of filtered lines.

Here is the problem:

I have a roster, I want to be able to count all the beds in a location leaving the occupied in place and counting the unoccupied or blank lines. PLease help. When you sow a thought, you reap an act. When you sow an act, you reap a habit. When you sow a habit, you reap a character. When you sow a character, you reap a destiny.

 

[ramani]

Hi

SELECT myView
Count For EMPTY(ALLT(MyField)) could be used

If you post the specific field names etc in the view, I can post the exact syntax.

View is just like a table and you can do the same way as you do to a table

Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK