Hi,

firstly, i,m not sure i have posted this in the right place, so

aplogies if i havent.

Secondly, i am new to VB, so any help you can offer - please could you explain it clearly - thanks

my question is this.

how do i create a bar graph in VB?

i have a database. In this database is a table called patients.

Within patients is a field called gender, in which it speifies all
the male/female patients.

I want a graph which displays the number of male and female patients in the database.

How do i do this?

I thought maybe something with SQL like this, but it doesent work.
SELECT COUNT(gender) FROM patient WHERE gender = 'male'
UNION
SELECT COUNT(gender) FROM patient WHERE gender = 'female'

If you have any other ideas for codes, please (if possible), could
you post the complete code on here?

Many thanks!!