J
jk
Hello,
Is it possible to have a query count out of two fields?
CDE CDE2
1 rba 1 fpa
1 rsa 1 zco
1 fde 1 spp
1 sdo 1 sec
------------------
4 4 TOTAL
I have two fields called CDE and CDE 2 i need to have a count for each
column.I have tried SELECT Count(CDE.code1) AS CountofNames but how do you
apply the sql if you want a count for each column?
Thanks
Is it possible to have a query count out of two fields?
CDE CDE2
1 rba 1 fpa
1 rsa 1 zco
1 fde 1 spp
1 sdo 1 sec
------------------
4 4 TOTAL
I have two fields called CDE and CDE 2 i need to have a count for each
column.I have tried SELECT Count(CDE.code1) AS CountofNames but how do you
apply the sql if you want a count for each column?
Thanks