Recent content by Adam1979

Soz , Me a ikkle bit fick What I have done isopened the database , created a new colum called NOP2 , copied the data from NOP to NOP2(numeric data) , deleted NOP and then renamed NOP2 to NOP , Problem solved. Im sorry for not understanding I do have a thick book "complete ASP , ADO and XML...

So what would the staement look like ? I admit , I wasnt thinking about the database when I created it , I know now though. All the entries in the NOP field are numbers , how can I add them all ?

NOP is set as a text field . I get the feeling this is bad news ,unless there is a magic statement that will read the text as numbers ?

Ok , I have a table called cons. I have a field in cons called NOP I would like to add the numbers together in this field and so used Select SUM(NOP) from Cons This cases an error "datatype mismatch in criteria expression" What is going on ? Adam I have looked at the database and the...

The bar chart would have to be dynamic as the numbers change daily

I LOVE YOU Im sorry , has been a long day and I have spent the last 24 hours trying to work it out in my head. The problem is that I use dreamweaver which normally writes in the querys via wizard type options. I have changed it as suggested and it works perfectly. Sorry If I was starting to...

Thasts the problem , I cannot post the query as I dont know which query to use. Currently I have SELECT DISTINCT accountname2 FROM cons This lists the 11 account names I have The table (cons) has 1600 records. Each of these records has an account name associated with it . I need to be able to...

Thanks for the super quick reply. I cannot get it to work though. It says too few parameters. The actual table is called CONS , I need to select Username from cons but only list distinct usernames ( there are only 11 in my database but there are 1600 records ) , Then count the amout of records...

Ok , I will try and explain this as best I can. I have a database and would like to run a DISTINCT query ( which I can do no problems ) I would also like to count the number of records at the same time. Say for example my database looked like this Name Fruit Adam Apple Carrie...