Search results for query: *

the statement i was using works fine in all my reports so far it's weird it had to cause a problem now.

the if statement you gave me works wonders!!!! thanks a lot you were great help!!!

tried that doesn't work either :s if i do a response.write on my sql it shows all suppliers but the problem is still happening when i display the data. if the supplier isn't found in the db it doesn't throw an error but instead moves to the next record.

i've read the same thing as well but it doesn't work unfortunately. I tried taking the supplier out of the query string as I'm not displaying it anywhere but that didn't work either. I've been on many sites but they all say the same thing...that the problem is with the db but that's all fine...

the supplier field is set as text and the rest are all numbers.

i just added the 2 following sql commands to my coding as i need to get some data from a different database. but it keeps throwing this error when i try to display the data from this new command: here's the code i've used to display it if objrs6.eof or isNull(objrs6("DisMonth")) = true or...

i am already doing that. what i need is the totals line like this: Acct Name Jan Feb Mar Reps-Code p12d Private £1000 £2510 £5203 2 r72t Retail £5965 £7512 £1316 2 TOTALS £6965 £10012 £6519 s87e Albion £2395 £1000 £500 19...

hi there, I am writing a report using ASP and am having trouble displaying the data in the way i want. I'm collecting turnovers for various companies and each of the companies has a county code. e.g. Yorkshire is defined as number 2. I need to group the companies together by county and need to...