getting a number count from query

[despatcher]

I have a db which keeps a record of my employees qualifications currently i can view a report which lists everyone in the company that holds a specific qual.

What i have been asked to do is design a form that will show an overview of all qualifications and how many people we have currently qualified. (reports/queries already setup to gather this data)

I have a stinking hangover at the minute had a quick play on access to try and figure out some sort of count function but i am struggling to focus. 1 hour until knock off.

Please can someone tell me how to get boxes on my form that will gather a count of each query and return that figure to the form (each different qual will have its own box on form)

thanks in advance
I hope this makes sense

 

[Oldsoftboss]

I have a stinking hangover at the minute...... i am struggling to focus. 1 hour until knock off.

Well done on making it through the day. (Or is the hangover from a big lunch )

Use a dCount in the recordsource of a textbox on your form

=dCount("FieldName","QueryName", Criteria)

Dave

 

[selvsagt]

How about making a crossquery.
You have the employee as rows, the qual as columns and a qualcount as data.

Qual1 Qual2 Qual3 Qual4
Emp1 1 1 1
Emp2 1 1 1
Emp3 1
Emp4 1 1 1
Sum 2 3 3 2

 

[despatcher]

Thanks for trying

No it was the drink not food that destroyed me for a whole day (wasn't there a time when you could drink like that and the following day would just be like any other?)

Anyhow guys i sorted myself out this morning and for info i used

= DCount("*","QueryName")

seems to have done the trick