Count Function - display a number

[antr]

Morning,
So doing this on excel is easy however struggling with the following on access.

I have loads of projects in a table, they all have a status (eg Red, Green, Amber).
I have a query for each so if you run qry_RagRed, it will show in a sheet all Red projects and obviously have a total in there.

So I have a form which has buttons on it for navigation, what I want is to display various things on there so for example, a field that simply has the number of red projects, or green etc.

All I want it to do is tell me a number based upon number of items in a query. There must be a simple way to do this but struggling to find one

If anyone can help that would be ace

Thanks

 

[pr2-eugin]

Have you looked into DCount?

 

[antr]

Hiya - I have tried that however its not web compatable which is a bit pants. I need something that works in a web form
Thanks

 

[pr2-eugin]

I am not sure if I have come across this issue of Domain function not compatible with Web Forms.. Maybe it is beyond me.. Someone should be along to help you.. Sorry I cannot be of much help..

 

[RainLover]

How are you using Access as part of a Web application.

What are you using as the Front End and the Back End.

 

[G37Sam]

You can do it with Access 2013:
http://msdn.microsoft.com/en-us/library/office/jj249372.aspx

I am yet to try it.