Hi,
i am trying to do this in VBA:
DoCmd.RunSQL "UPDATE [Static Data] SET [Static Data].Result = max([Courses].[COURSE ID]) WHERE ((([Static Data].Criteria)='CMAX'))"
it basically stored in a table called STATIC DATA the highest Course ID value. It doesn't work and has this error:
"You tried to execute a query that does not include the specified expression 'Result'...."
Any help is appreciated!
i am trying to do this in VBA:
DoCmd.RunSQL "UPDATE [Static Data] SET [Static Data].Result = max([Courses].[COURSE ID]) WHERE ((([Static Data].Criteria)='CMAX'))"
it basically stored in a table called STATIC DATA the highest Course ID value. It doesn't work and has this error:
"You tried to execute a query that does not include the specified expression 'Result'...."
Any help is appreciated!