Dcount problem

N

nicolascaprais

Hey y'all,
I have a table with three fields
|KEY|KEY_Tbl1|KEY_Tbl2|
The fields KEY_Tbl1 and KEY_Tbl2 each have numbers in them (1,2,3 for
field KEY_Tbl1 and 10,11,12 for field KEY_Tbl2).
I can count how many 1,2,3,10,11,12 there are in each tables but my
real problem is:
How can I count, using a query or a module for each possible case (9
possible), how many entries have:
- KEY_Tbl1=1 and KEY_Tbl2=10 or
- KEY_Tbl1=1 and KEY_Tbl2=11 or
- KEY_Tbl1=1 and KEY_Tbl2=12 or
- KEY_Tbl1=2 and KEY_Tbl2=10 or
(...)
- KEY_Tbl1=3 and KEY_Tbl2=12

????? Can some one help me?
As no one stops raising the level of difficulty (for my knowledge I am
at a limit close to infinite on this one!!!), if that person knows how I
can get rid of the field value (1,2,3,10,11,12 ) and have this query
count for me the number of times
KEY_Tbl1=" any value" and KEY_Tbl2="another value"
Giving as an output the values of KEY_Tbl1 and KEY_Tbl2 and the number
of times they are found on the same line in my table...:confused:

Thx for your help
nico
 
D

Dale Fye

Nicolas,

Try something like:

SELECT [Key_tbl1], [Key_tbl2], Count(*) as Freq
FROM yourTable
GROUP BY [Key_tbl1], [Key_tbl2]

--
HTH

Dale Fye



Hey y'all,
I have a table with three fields
|KEY|KEY_Tbl1|KEY_Tbl2|
The fields KEY_Tbl1 and KEY_Tbl2 each have numbers in them (1,2,3 for
field KEY_Tbl1 and 10,11,12 for field KEY_Tbl2).
I can count how many 1,2,3,10,11,12 there are in each tables but my
real problem is:
How can I count, using a query or a module for each possible case (9
possible), how many entries have:
- KEY_Tbl1=1 and KEY_Tbl2=10 or
- KEY_Tbl1=1 and KEY_Tbl2=11 or
- KEY_Tbl1=1 and KEY_Tbl2=12 or
- KEY_Tbl1=2 and KEY_Tbl2=10 or
(...)
- KEY_Tbl1=3 and KEY_Tbl2=12

????? Can some one help me?
As no one stops raising the level of difficulty (for my knowledge I am
at a limit close to infinite on this one!!!), if that person knows how
I
can get rid of the field value (1,2,3,10,11,12 ) and have this query
count for me the number of times
KEY_Tbl1=" any value" and KEY_Tbl2="another value"
Giving as an output the values of KEY_Tbl1 and KEY_Tbl2 and the number
of times they are found on the same line in my table...:confused:

Thx for your help
nico
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Loop 0
Dcount -Date Criteria - Won´t find it - 0
How to count the numbers in a Word document? 0
Custom toolbar button for search and replace 1
Is this possible? 0
Finding the right style field in VBA 0
Insert name and adress from a list in a word document 1
Need some PWA help 0

Top