[AccessD] custom sorts/groups in a report

You can only group and sort on a field or an expression involving a field,
and no, you can't use variables.  Had you mentioned the variable before?
Why not just create a "week" field in the query and group and sort on that
calculated field.  Then you could use your variable to create a filter for
the particular week in question.

============I'm passing the firstdayoftheweek value from a form to the
report -- the report's based on a query. So that's the quandry. That's what
I mentioned in my last message -- the only way I can see around it is to
pass the value to the query and run the expressions in the query first. I'm
not sure I know how to do that really -- I have never passed anything to a
query before -- just called functions from a query. And in this case, that's
what I'm trying to avoid -- calling the function from the query. 

Susan H.