How can I count the number of records in Update query

[danial]

How can I count value in Update queryHow can I count the number of records in Update query

Because I don't want create normal query for count it.
Realy I want to count rec. before update data
any way for me?

Thanks

 

[SydneyGeek]

In code, I don't think you can do it.
Also, I don't think you can use an action query as a data source for another query.

The reason is that, whenever you work with records in a query, Access works with the associated Recordset -- and you cannot create a Recordset from an action query as far as I know.

So, if you want to know the Sum and the Count of a set of records, you need to work with a standard query -- you can see the Count on the warning that Access is about to update xx records, but that's about it.

Denis

 

[danial]

I have a form for interface with user.
I want to show the count of record on the form as below

My Form

Do you want to update [240] records
[Click hear for update]

but if that "query update" have not data.
I want to show

Can't not updata data now!

 

[Andrew Fergus]

Hi Danial
Instead of using the update query as the source for the number of records, use another query that uses the identical criteria to count how many records would be updated by the other query.
HTH, Andrew