Sort/Hiding Fields

[Cassidy]

Hello, I have a table of about 250 items that are sorted based on two fields. I created a query of the table and hid one of the fields because it is only there for sorting purposes to group the data.

For example, I have a "Type" field. In the type field, I differentiate the items with different categories, such as "Materials", "Safety", etc. My next field is "subtype" which assists the "Type" field being sorted properly for my needs. In the "Materials" category, all of the items are either "Fencing", "Plastic", "Wire", or "Miscellaneous". I am sorting the "type" and "subtype" fields in ascending order so that all the "materials" are grouped together, and all of the "fencing, "plastic", etc are grouped together within the materials field.

I am creating a printable report and I do not want the "subtype" field to be on the report, but I need the "subtype" field's sort to be affecting my data so it is grouped properly. I'm having difficulty, is there a way to hide fields in reports? Thanks for any assistance!

 

[pbaldy]

You can certainly hide a textbox by setting its Visible property.

 

[Cassidy]

I know I can hide it in a query, but can I hide it in a report? I have included a screenshot of my query. I want my report to include the sorting from the "Subtype" field without the "subtype" field being visible on the report. Can you hide fields as simply as with queries or is there someone else I must do?

Also, can you sort a report by two fields? When I try to apply both it seems that only one is staying active.. :banghead:

 

[pbaldy]

I meant a textbox on a report. You can sort by any number of fields, but it has to be set up in Grouping and Sorting.