My Assistant
Site Message
(Message will auto close in 2 seconds)
 Counting the number of occurences per domain
|
|
 Aug 10 2004, 08:18 AM
Post
#1
|
|
|
UtterAccess Member Posts: 46  |
Hi!
I am trying to run a query to find out how many projects (ProjectID) occurences there are per organisation (OrgCode). DCOUNT doesn not seem to work because it requires a criteria, I don't want to count the number of projects for organisation "1" only, I want a list of all organisation numbers with next to that the number of projects each organisation carries out. Hmm I'm sure someone has asked this before but I cannot find the answer on the forums... Thanks for any help! Daniel. |
 |
 
|
Posts in this topic
Daniel_Reijer Counting the number of occurences per domain Aug 10 2004, 08:18 AM
ScottGem Re: Counting the number of occurences per domain Aug 10 2004, 08:22 AM R. Hicks Re: Counting the number of occurences per domain Aug 10 2004, 08:22 AM Daniel_Reijer Re: Counting the number of occurences per domain Aug 10 2004, 08:43 AM ScottGem Re: Counting the number of occurences per domain Aug 10 2004, 09:00 AM Daniel_Reijer Re: Counting the number of occurences per domain Aug 10 2004, 09:19 AM
ScottGem Re: Counting the number of occurences per domain Aug 10 2004, 09:35 AM |
  |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 02:57 AM |