Susan Harkins
ssharkins at bellsouth.net
Mon Apr 19 12:28:13 CDT 2004
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