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
Tidak ada komentar:
Posting Komentar