I have a text box on the form that i set to run off of a macro. The
macro
runs a query that takes the sum of an attribute called
meeting_actcost from
the meeting table where the employee_department matches whats put in
the
prompt.
I keep getting a error saying " Access cant find the macro ' WHERE
Budget'.
I made sure i saved it,so i know it exists. This is the SQL that the
query:
SELECT DISTINCTROW Sum(Meeting.meeting_actcost) AS [Sum Of
meeting_actcost]
FROM (Budget INNER JOIN Employee ON Budget.employee_department =
Employee.employee_department) INNER JOIN Meeting ON
Employee.employee_code =
Meeting.employee_code
WHERE (((Budget.employee_department)=[Enter Branch]));
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
