counting records from an update query

[PhilipEwen]

I am trying to count the amount of records that have been updated from an update query..
ss = "UPDATE flights SET flights.departairport = [Forms]![flights]![txt_depart], flights.arriveairport = [Forms]![flights]![txt_arrive], flights.duration = [Forms]![flights]![txt_duration], flights.flightname = [Forms]![flights]![txt_flightname], flights.price = [Forms]![flights]![txt_price] WHERE (((flights.traveldate) Between [Forms]![flights]![txt_date] And [Forms]![flights]![txt_dateto]) AND ((flights.flightsresortid)=[flightsresortid]));"

'On Error Resume Next
DoCmd.RunSQL ss

I have tried the DCount function, but that won't let me Dcount ("*", ss)
i presume the Count function is the way to go, but not entirely sire where i'd put that in ss

Any ideas ?

 

[PhilipEwen]

Forget it - got it sorted.

RTFM !!