获取列中类型的总计数，例如性别 [英] Getting total counts of types in column, for example gender

问题描述

我有一个带有字段性别的表（tblMain）。我正在尝试计算女性和男性人员的SQL，以便我可以更新包含两个字段男性=和女性=的表单。


存储在tbl是M和F。


谢谢！

解决方案

到目前为止你尝试了什么？

按性别使用聚合查询分组。如果你真的需要两个不同列中的结果，请使用交叉表。

啊，兔子......我打算建议......只是想看看他们尝试了什么到目前为止:)


（虽然我有一个温暖的模糊，我在正确的轨道上）


:)


-z

I have a table (tblMain) with field Gender. I am trying to get a count in SQL of Female and Male personnel so I can update a form containing two fields "Male = and Female = ".

The values stored in the tbl are "M and F".

Thanks!

解决方案

What have you tried so far?

Use an aggregate query grouping by the gender. If you really need the results in two different columns, use a cross tab.

ahh, rabbit... I was going to suggest that... just wanted to see what they had tried so far :)

(although I have a warm fuzzy that I was on the right track)

:)

-z

这篇关于获取列中类型的总计数，例如性别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！