Help with query statement

[wolfm]

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!!

[JoeM]

Can you post the SQL code of that query you are referencing?
If you switch the query to SQL View, you will see the SQL code. Just copy and paste it here.

[CJ_London]

Have I typed the statement incorrectly

no - but your naming convention will cause you problems down the line - it is strongly recommended not to use spaces or non alphanumeric characters in table/query field names.

With regards your error - perhaps you refer to 'process date' elsewhere in the query