Update query with count

Dear Experts

now i make a select query
as

select header,count(header)
from database
group by header

which create a new database with my requirement then i have to do query as lookup to update my existing databse :-(

here i want an UPDATE query which can update my existing database instead of new :-)

Pl. help


R's
Amit Kumar

Sorry but is didnt get i have the same issue

i want my database to be updated with UPDATE query

pl. tell me the query

Here i attached a ms-access template 2007.

Which Contain two field as given below

Cellno, Cellno count
9627771750 1
9627771751 1
9627771752 5
9627771752 5
9627771752 5
9627771752 5
9627771752 5
9627771757 1

Note:- i need this in one update query in updateable table..

now a days i use this query

select Cellno,count(Cellno)as [Cellno count]
from Dbase
group be Cellno

result is a non-updateable table get create the i have to map this into my main file

hope u understand what i need??

Thanx alansidman

But facing one more Problem.

in this query i have to check manual dbase and delete the record 1 among 2 or 2 among 3

Is there any query which can get the result as Excel like True False.(may be some thing else)

E.g if a Cellno. having 3 time in a table then qwery shown 2 time True and 1 time False (may be some thing else)
so that i could delete easily the cellno which is multiple time,

hope u understand what i need..

Thanx for giving me solution

But if i do this with a single column as (select distinct Cellno from Dbase) then it works properly, but if i do this with multiple data then it doesn't work.

I m using this query

(select distinct Cellno,* from Dbase)

Pl. look where m creating mistake

I also attached as Sample data sheet. pl. look into this..

R's
Amit Kumar

If this is what you are looking for..

SELECT Tb2.Number, Count(Tb2.Number) AS CountOfNumber, IIf(Count([Tb2]![Number])<>1,"Multi","Single") AS Status INTO NewTable
FROM Tb2
GROUP BY Tb2.Number;