[AccessD] custom sorts/groups in a report

But I've tried and it won't take it. The OpenArgs argument passes the value
I use in all of the date functions. If I refer to is as a variable 

=DatePart("ww",field,int)

I get a parameter prompt asking for int. I even tried setting a text control
to the openargs value and referring to that

=Date("ww", field, txt)

Either way, the sorting and grouping dialog doesn't like it and shows a
parameter prompt asking for txt. 

Everything I've read says the sorting/grouping needs to refer to a field. I
was trying to avoid having to pass the firstdayoftheweek to the query
itself, but I guess that's an option. I guess I could pass the value to the
underlying query and run the week number calculation in the query, instead
of in the report.  

Susan H. 

Susan,

You sort/group on a calculated expression by entering that expression in the
grouping and sorting dialog

Charlotte Foust

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net]
Sent: Monday, April 19, 2004 9:28 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] custom sorts/groups in a report


Well, checked again -- unless I'm just missing something, I don't know
how to group/sort by a calculated control within the report itself.

Susan H.   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, April 19, 2004 1:17 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] custom sorts/groups in a report

Gustav, I've not been able to sort by a calculated control -- wait... I
think I've been doing it wrong -- duh... <hangs head> I'm SUCH a user...
;) 

If I'm right, I'll let ya know. :) 

Susan  H. 

Hi Susan

Then, in the report, can't you sort and group by

=Weekday(YourDate, [YourSelectedFirstWeekday])

/gustav


> That's what I'd rather do, simply because it leaves fewer holes.

> Susan H.

> Hi Susan

> Your method looks longwinded but not weird. If it works fast and well
> I would leave it, though I'm sure another method could be found where 
> you adjust the grouping in the report directly.

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com