I am taking a class on Lynda.com about appended queries.
The instructor talks and types really fast, also the formulas are difficult to see.
I want the [Process Date] field in the query "qry_OpenJobs (no posting type)" to appear in the dataset.
I have it written as:
Snapshot Week: DatePart("ww",[qry_Open Jobs (noposting type)].[Process Date])
I get the error code as attached...
Have I typed the statement incorrectly?>
Thanks!!