Search results for query: *

select convert(int,'-') brings back 0 so it looks like that's another way of sayinf zero! select '-'+3 brings back 3! Interesting.

That's not a bad idea - the table structure will always be the same as they normally just select *. Didn't know you could do that - thanks! I'll see if it's any quicker.

Thank you for your response. The query selects from probably about 30 or 40 tables. There are about 200 fields and the number of rows depends on the parameter values- but it's normally in the thousands. The select query, as I mentioned takes about three seconds, when it's a make-table it takes...

Hi, I have an access project which is liked via OLE DB to a SQL Server. It uses NT authentication. I want to create a query on it. As far as I can see (new to Access projects) the way to do this is to create a new view, which actualy does create a view in the SQL Server db. So I have given...

Hi, I have a query which is incredibly slow. It's a make table query but when it's changed to a select query it runs in <3 seconds (still slow I know, but not half an hour!) Does anyone know why this is happening and how it could be fixed? Thanks for any help

Tracy, I know what you mean about fingers getting carried away - I have trouble writing the word 'form', my fingers insist that it should be 'from'. I also add a 'g' on to the end of any word ending in 'in' (travelling on the traing). On the other hand (pun intended), maybe I just cn'at tyep...

I don't understand, are these reason1, reason2...reason5 fields already set up? Or are you going to have a link table which would be a much better solution? If the fields I mention above aren't already created and you can't change the table structure, what do you intend to do?

select ... where (field1 = 'b' and (field2 = '1' OR field2 = '2')) or(field1 <> 'b' and (field2 = '1' OR field2 = '2' OR field2 = '3')) ..I think!

If the table structure is already prepared then my suggestion will work - just create the update statement.

What exactly ae you trying to achieve with the aggregate? Can you post the query exactly as you ran it?

That shouldn't cause a problem, what is the error?

There will be a way to do it, but the easiest way in my opinion is to get the PK field and this field into excel, delimit the field that has reasons separated by an underscore, change the table structure, build up an update string for each one in excel and then run the created strings. May not...

SQLBill - IIIII see :)

Why is it not syntax? Do you mean it depends on the version?

From your query I can't see why - what other class codes are returned? If you add the class code to the select statement, can you show us some sample output?

The SQL Server equivalent is the case statement.

if you try (columnname is null or columnname <>1) what do you get?

you have written 'innert' rather than inner. If that's just in the post and not the syntax let us know.

Id you have a summary field already set up, just move it or copy it into your report footer. Did that work?

Are you sure? What happens if you do: SELECT COUNT(MachineID) AS Total, DisplayName00 AS Application FROM Add_or_Remove_Program_DATA WHERE (DisplayName00 = 'Adobe Reader 7.0') OR (DisplayName00 = 'Microsoft Data Access Components KB870669') Do you get them all or only the two...