Data in a Header

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

I have got a sort and group that I can not do with the standard tools.
I need to be able to sort and group by two fields, access is only limited to
one.
Question,
I have got a query that returns three months(qtr.) worth of data. In that
query I have got a month field. Is there a way to put 3 rows of boxes in a
header group and retrieve each months critirea by setting the boxes controls
to a certain row in the query? If so how do you refer to the queries return
Thanks
David
 
You could always concatenate your two fields into a new
field in your query. Then, you could base your report's
sorting and grouping on the 1 new field. Something to
think about.
 
I frequently use sorting and grouping by multiple fields
and have never had a problem.
in the sort/group filed enter
=[field1]&[field2]
substitute your own filed names.
Hope this helps
 
Back
Top