Started with a predefined form, but want to change layout

[snowboarder234]

The fields are all locked. How do I break them apart so I can move them around?
MS 2011
Windows XP

[pbaldy]

Highlight one or more, right-click and select Layout/Remove.

[snowboarder234]

Thank you for your help. Two more quesitons:
1. How do I shrink this down to fit on an 8 1/2 x 11? Right now it only fits on an a 8 1/2 x 14
2. I have the first sort by the grant number. How do I get a secondary sort so that the names are sorted alpha with the corresponding grant number?

Thank you.

[snowboarder234]

Thank you for your help. Two more quesitons:
1. How do I shrink this down to fit on an 8 1/2 x 11? Right now it only fits on an a 8 1/2 x 14
2. I have the first sort by the grant number. How do I get a secondary sort so that the names are sorted alpha with the corresponding grant number?

Thank you.

[pbaldy]

Well, generally speaking you would shrink down the size of controls until you achieved the look you wanted. As to the sort, you'd add the second field in Sorting and Grouping.

[snowboarder234]

Well, generally speaking you would shrink down the size of controls until you achieved the look you wanted. As to the sort, you'd add the second field in Sorting and Grouping.

The report includes years 2004 - 2011. I want it first sorted by year. I figured that out. The year also includes the grant number, ie; 04-217. But then, within each year, I want the names sorted by alpha so it it is properly assigned to it's grant number.


Do I have to manually do a separate report for each year to achieve this?

[snowboarder234]

The report includes years 2004 - 2011. I want it first sorted by year. I figured that out. The year also includes the grant number, ie; 04-217. But then, within each year, I want the names sorted by alpha so it it is properly assigned to it's grant number.


Do I have to manually do a separate report for each year to achieve this?

Just ignore the above request. If someone could just tell me how to break out the grant numbers thusly:
all the 04'S in one report, all the 05's in one report, etc. I theorize that if I do that then I can achieve my goal of getting the names sorted by alpha while grouping each year in a separate report.
Right now the table contains grants numbers starting with 04 - 11. Again, my goal is to break it down into years (aka grant number) then alphabetically within the year. I think doing a separate report for each year (while time-consuming) will be easier at this point.

Thanks for the help.

[snowboarder234]

Just ignore the above request. If someone could just tell me how to break out the grant numbers thusly:
all the 04'S in one report, all the 05's in one report, etc. I theorize that if I do that then I can achieve my goal of getting the names sorted by alpha while grouping each year in a separate report.
Right now the table contains grants numbers starting with 04 - 11. Again, my goal is to break it down into years (aka grant number) then alphabetically within the year. I think doing a separate report for each year (while time-consuming) will be easier at this point.

Thanks for the help.

If you have a suggestion for doing this at the query level in the criteria field it would be helpful.

[snowboarder234]

If you have a suggestion for doing this at the query level in the criteria field it would be helpful.

In the query criteria field for the GrantID I used: <"04_45" -- that gave me all the 04 grants, thus excluding the years I didn't want. Once I've grouped all the 04s into one report, I can then sort it alpha by name. I'll repeat the process for 05, 06, etc. Not very elegant, but it will get the job done for now. I'll be back.......

[pbaldy]

You might also try adding a calculated field:

Left(GrantID, 2)

which would let you put a parameter on that field and get any year you want. Or a similar thing with a date field if you have one:

Year(DateField)