Search results for query: *

Hi all, I have a setup where I have my server application in one domain, and the user account names are duplicated on 2 trusted domains (domain1 and domain2). When a user logs in to the application, I can see that the LookupAccountName win32 function is called to find the user acccount on the...

Hmmm - yes I could execute the SPO from Query Analyzer on both machines, but this helped me find the problem! It turns out that I was enclosing each SP call parameter in brackets [] in Query Analyzer, but not in my application call out. Usually this wouldn't matter, but my remote server2 has a...

Hi there, I hope someone can help me here as this is driving me nuts...! Ok - I have an application which calls stored procedures from two machines: 1. Windows 2003, SQL 2005 2. Windows 2003, SQL 2000 If I call the stored procedure on server1, everything works ok. If the same stored proc is...

It's now sorted - and works exactly as it should. Eventually got this working with the help of CONVERT... (hides embarrassment). Thanks anyway!

Hi all, I am trying to assign a variable the result of a query in a stored procedure. At the moment, the line is: select @reqid = (select o_reqid from swpro.staffo where o_casenum = @caseref) The SP should then insert the variable into a concatenated string and wriet this string to another...

Hello all, Hopefully someone can help me out here! I have a table which includes the following fields: Client_Ref, Client_Name, Partner_Ref Each client is either an end user or a partner. If they are an end user, their partner_ref references the client who deals with them by their...

Hello all! I have a very simple statement on a report which reads: =Sum(IIf([Current_Category]="A" & [Response_Met]=1,1,0)) This is to provide a count of those records in a table where the category is A and the response time has been met (=1). Perhaps I have overlooked something, or...

Help! I have a table which contains updates to support calls. I need a select query which will select the latest update to a support call - this will entail selecting only those records where the problem_id for each call is the highest. For example: Call_number Problem_id 1-1-1...

Very useful info - thanks! One more thing - Is it possible to perform this type of operation in a query? Cheers. Chris.

Hi all! In need of some more help.... I need to be able to join the contents of 3 different fields into one new field, as I'm trying to create call numbers, which are made up from the amalgamation of region_number, client_no and ref_no. (The rather deficient storing of this information...

That works beautifully....!! You're a genius and a gentleman...! Cheers. Chris.

I don't suppose you (or anyone) could elaborate on that a bit - i'm only a mere Access rookie, and I still can't get it working... Every time I try any kind of COUNT expression, I get the total number of records for the group, rather than the number of specified records. Many Thanks. Chris.

Afternoon all! I'm trying to use the COUNT function to display the number of records in a group footer on a report where values in one of the fields = 1. In short, does anyone know how to specify criteria in a group footer using COUNT? I've looked briefly at using DCOUNT, but this gave a...

Hold the phone......! This is down to something machine specific - the query runs fine on another installation of Access! Still no idea what is causing it though..... Cheers. Chris.

Good point, but yes - it appears that the data types are the same: slaclienttable.REGION_ID = Num slaclienttable.CLIENT_REF = Num slaclienttable.Current_Category = Text slatimes.REGION_ID = Num slatimes.CLIENT_REF = Num slatimes.CATEGORY = Text Any other ideas...? Chris.

Hi all! Can anyone tell me why this simple join query is returning 0 rows? All I am trying to do is create a new table holding the required response times held in one table for various support calls held in another. The statement is: SELECT slaclienttable.*, [slatimes].[INITIAL_RESPONSE] INTO...