ACCESS FEED: [MS_AccessPros] Re: Help with reports

Jumat, 11 Mei 2012

[MS_AccessPros] Re: Help with reports

John -

What I want to do is generate a report based on 1 query which includes all of the information from tblFMLA. I want the report to display all active records, and to sort those records based on which type of FMLA they are using. (i.e. all intermittent fmla records would be grouped together and the report would display the group heading. If you'll look at the reports I already have in the database; I want a report just like that but just 1 report instead of a seperate report for each group.

I hope this provides more clarification.

Thanks for your help!

Katrina

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Katrina-
>
> I have your database, but it's unclear to me which form you're talking about and
> with report(s). Can you enlighten me?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
> Sent: Friday, May 11, 2012 3:57 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Help with reports
>
>
> I have a query with several fields that have the criteria "true" so that if the
> record has that field checked it will display on my report. My question is when
> I create the report is it possible to have an automatic header displayed based
> on that checkbox field. Example: The fields are named intermittent fmla,
> occupational fmla, non occupational fmla....etc. I want my report to sort the
> records based on what field is checked, and assign a header to the report also
> based on that field. I'm not sure if I'm making any sense at all. I want to
> create 1 report that will display all the records sorted by the checkbox field.
> Currently, I have a seperate report for each one. I have uploaded my database
> for review in the Assistance Needed folder.
>
> Any help is greatly appreciated!
>
> Katrina
>