Hi All,

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
Ben

Hi Ben,
I think you can do this by setting the criteria in the Row_Date field to >#??/??/????# entering the date from which the new data commence. This should avoid the aggregate function.
Barry