report groups not grouping right???

[misscrf]

I have a database, and I am looking to add a somewhat master statistical report.

The database is for candidates that apply at my work, for a job. The statistical report will be for counting who we have hired.

The factors are what department they were hired to, what office, and what candidate type they are.

The db is in 3rd normal form with lookup tables for any "type" or factor that has to do with a candidate. If you are really interested to see the table relationships, see an image here

Anyway, my goal is to have the user enter a beginning and end date for their criteria, which will be pulled from the start date that the candidate was hired.

Then the report would show the statistics for hires during that time period. It would look like the following:

Office Hired to:

New York City - 10
Boston - 15
Chicago - 30


Department Hired to:

Human Resources - 8
IT - 12
Finance - 24
Marketing - 6


Candidate Type Hired:

Administrator - 13
Analyst - 27
entry level - 21
intern - 9

Total Hired Between dateA and dateB: 50

Then I would like to add a chart (time line of hire ups and downs, or maybe bars for each factor, not sure, but I am not worried, because I can usually do charts no problem.)


right now, no matter what I do, I get

office:
New York - 1

Candidate type:
Administrator - 1

Department:
Human resources -

-------------
office:
Boston - 1

Candidate type:
Analyst - 1

Department:
IT - 1

and so on...
for each record.

If anyone can help me to get this to group right, I would really appreciate it.
Thank you.

 

[lieberb]

I may be over simplifying the matter, but it looks to me like you need a form where the user can enter the start end end dates. Then 4 Queries, with that forms text boxes as criteria. You can then combine the 4 queries into a report (or maybe 4 sub-reports, one main).

This shows the basics of the form\query building: http://www.microsoft-accesssolutions.co.uk/query_filter.htm

Hope that helps

 

[misscrf]

thank you for responding. I do not see the 2 form fields for start and end date is not the problem at this point. I understand that once I have a report based on a query, I can put a criteria in the corresponding query field for [form][formname][formfield]

and then have that field on the form that will be the report menu.

My issue is that, same as the link you posted, I am not looking for a count of 1 item in one of the categories, I am looking for a count of each item in all of the categories, grouped by category.

It is the setting up of the report, that isnt working.

I tried 1 report, I tried 1 report with 4 sub reports
either way it wont seem to group right. I would think that someone would have created a report like this before. Anyway, If you would like me to explain further, I would be happy to do what I can. I would love to find an answer.

Thanks.

 

[misscrf]

chart time? :-S

Well, I think I am past the initial problem. I have a subreport for each category that I want to report my statistics on. One for candidates hired by office, one by department, one by application source, and so on.

Now I am just working to make a chart for each category. I wish I could use excel for this, but the chart isnt refreshing.

Is anyone really good at charts? I could use the help.

 

[Pat Hartman]

You can force the chart to refresh (this is a problem with computers so fast they get ahead of themselves) by adding a requery to the Format event of the section that holds the graph.

Me.MyGraph.Requery

 

[misscrf]

It is not just refreshing the chart on the access side, but in doing this, I am not technically opening the excel chart and refreshing IT. Will this do that? Refresh the data for the excel chart?

I will try this out. Right now I am working on a report menu, but I will get back to this issue. Thanks.