graph question

[Onslaughtdave]

Hi,

I want to make the lengend say something besides countofemp.

how do i change it so it will stay what i change it to.

thanks,

dave

 

[OnTheFly]

In the query that creates the field name CountOfEmp to what every you want. To do this you would enter the name you want followed by a colon at the begining of the field being counted or go to the SQL of the Query and add an AS like this:

Count(Emp) AS [Number of Employees]

Hope this helps.

OnTheFly

 

[Onslaughtdave]

Ok, can i do something similar with a sql select statement?

 

[OnTheFly]

Yes, as I explained in the previous post, add the AS part to the appropriate field:

Count(Emp) AS [Number of Employees]

If this is still not clear, please give me your SQL statement and I will show you where to place the AS.

Hope this helps.

OnTheFly

 

[Onslaughtdave]

ok i found out what it was. sorry didnt see that until after i posted lol...but i was tring to use a label which was a field already...

thanks.