Hi,
Help me out here. It maybe a simple thing to do. But I just can’t get it right!
In a DB I use one form with a “Status” field. I use 3 different status: Red, Green and Blue. I want to create a view witch count those different status informations. How many forms that have the status Red, Green, Blue
Like this:
Red: 8
Green: 3
Blue: 4
When this is done, I want to use this information in another DB and show it on a webpage.
Can Anyone help me out here?
Thx
Richard
Subject: Count Status and show result on web
create a view, first column should contain your status field value and should be categorized. Create a second column with value formula: 1. On the column properties, make the column to Total and check hide detailed rows.On view properties, set to Collapse all when view is opened.
Embed this view in your other database. This will give what you want but users will be able to expand categories and view the documents. If you don’t want this, create a form and use a webqueryopen agent to read the information from view and transfer it to the form.