By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

Custom Report in Acces 2003 Database

P: 1
I am trying to create a custom report that will allow me to records appear under a common label. What I am getting is the label will repeat on each page with a single record. I have six separate lable categories and I am capturing the data for each from the form. I get the separation on the query and table. I would like to have all of the common records to each label appear under that label not 1 record per label. I hope this makes sense, I am a novice Access user and I am racking my brain to solve this.

Example of what I want to do.

Label: Goal 1 Activities:
Record One
Record Two
Record Three

Label: Goal 2 Activities
Record One
etc.

I appreciate any help.
Nov 13 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I am trying to create a custom report that will allow me to records appear under a common label. What I am getting is the label will repeat on each page with a single record. I have six separate lable categories and I am capturing the data for each from the form. I get the separation on the query and table. I would like to have all of the common records to each label appear under that label not 1 record per label. I hope this makes sense, I am a novice Access user and I am racking my brain to solve this.

Example of what I want to do.

Label: Goal 1 Activities:
Record One
Record Two
Record Three

Label: Goal 2 Activities
Record One
etc.

I appreciate any help.
You can only set groupings on field values.

Go to View menu and choose Sorting and Grouping.

This will allow you to group records under a particular field by choosing each one from a drop down list.
Nov 13 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.