Append Query Criteria
I need to create an append query to append data from Table A to Table B, the data I want to append from Table A will have a date after the latest date in Table B.
I have created an append query to append all fields from Table A to Table B with a criteria set on the field "Row_Date" >Max([tableb]![rowdate]), however I get the error message cannot have aggregate function in where clause.
Whats the best way round this?
Thanks in advance