multiple totals in one report or form 1

[Regelos]

What I'd like to do is create a form or report >or both< that gives me record totals off multiple datasets

ie: I want to know how many records I have for 10/16/2005 total then I want a breakdown of how many where Escalated >yes no checkbox< how many where recieved by a phone call >yes/no checkbox< is just record count of each indvidual thing. Management wants to see both yes and no answers broken out.

Thank you in advance.

 

[missinglinq]

Reports/forms from multiple tables is done by creating a query using data from each pertinent table. The report/form is then based on the query result.

Hope this helps!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[Regelos]

I am only using one table to store this information. do I have to break those indivual fields down to differant tables or can I just use one table across the board?

 

[spizotfl]

you can keep it in the same table, just make queries to pull the data you want and base the reports on the different queries.

 

[Regelos]

what I want is one catch all report or statusboard form. I cant seem to get the report to let me enter multiple queries.

 

[spizotfl]

how about using subreports based on the different queries and placing those on a main report?

 

[Regelos]

thanks I'll try that. Reporting is my weakest function of access....

 

[Regelos]

I was working with this last night and I still cannot get it to work.

I have to provide basic metrics every day # of total calls, # of calls phones in, # of Calls Escalated, # of calls closed, and # of tickets closed. I have fields for this and so far I can get individual querys to work. on the ones I've tried but I cannot get one form or report to let me combine those queries.

 

[spizotfl]

how do you have all of this stored in the underlying table?
it sounds like you need totals from fields in the tables, in which case you need some totals queries...