Harry Taylor
Registered User.
- Local time
- Today, 20:19
- Joined
- Jul 10, 2012
- Messages
- 71
this is probably a basic questions but i've been struggling for hours.
I have a table RA
in this table i have columns - VisitDate, Week (week number) and SC (services done)
In a Form i have a subform and use a drop down menu ([combo6]) using the Week. i.e. Week 26 lists the SC's done that week in date order (typically Mon-Fri)
I want a text box Dsum which will will show Year To Date services from the week selected - so Week26
I'm miles off but i have tried these;
=DSum([RA]![SC],[RA]![Week],"[RA]![Week] =>[combo6]")
&
=DSum("SC","RA","RA=""combo6")
I have a table RA
in this table i have columns - VisitDate, Week (week number) and SC (services done)
In a Form i have a subform and use a drop down menu ([combo6]) using the Week. i.e. Week 26 lists the SC's done that week in date order (typically Mon-Fri)
I want a text box Dsum which will will show Year To Date services from the week selected - so Week26
I'm miles off but i have tried these;
=DSum([RA]![SC],[RA]![Week],"[RA]![Week] =>[combo6]")
&
=DSum("SC","RA","RA=""combo6")