Search results

I am workling on a report in access 2000. I have a report on the kids in my group and one of the groupings is by age. I have age ranges such as under 10, 11-12, 13-15 etc In my report I count the number in each group but the weirdest thing happens. I inserted a chart and the legend comes up...

thanks, I'll try

Thanks for your quick response I do have a field called age but where do I put the code you wrote (sorry for my stupidity)

I have a report with students ages ( 10, 11,12,13,14,etc) I want to make a report angd have an age range like (0-10, 11-13,14-17 etc) How is the best way to do this

thanks, I'll try now

I just got a new machine with office 2003 but it doesn't include ms access. Can I use access2k with this new version of office?? so I can do reports and put them into word etc??

I have a form with some drop down boxes The form is based on a table One field is lastname and one is firstname The row source is based on table/query The lastname field works fine but the firstname brings in the lastnames What am I doing wrong

it is not a linked table and I'm trying to create a new workbook

I am trying to export a table from access 2000 to excel 2000 and keep getting an error message "external table is not in the expected format" What should I do

thanks, I'll try it

I have to do a report of cases I've worked on during the year I can tally gender (m,f) =Sum(IIf([sex]="f",1,0)) then I do it again for M Is there a way to group "age" such as 11-13.14-17 etc. I did it in a count but now I want to summarize in the report footer

thanks, I will try it

I need to do an annual report for all the cases I reviewed all year I have a lot of fields such as age,gender,IQ,ethnicity, referral source, county etc... I need to count how many in each field What is the best way to to achieve this Thanks

You explained it well and I just did it

When I go into a report I would like to see what the report is based on, (query, table etc.) What is the best way to do this

thanks I will try this

I have a database where I record my clients visits(sessions) I have a field with the number of sessions allowed and another with the session history I would like to know how to query the table so as to total the number of sessions for each client

Thanks, but is there a way to do this on the report and not in a query

I'm not sure of the syntax for counting males and females in the expression

I am running it form a query and I will try what you suggest