Search results for query: *

Assuming each invoice record has a customer field: SELECT Invoices FROM table WHERE (Customer IN (SELECT Customer FROM table GROUP BY Customer HAVING COUNT(*) > 3))

Another option... DECLARE @GoodMails INT, @BadMails INT SELECT @GoodMails = GoodMails, @BadMails = BadMails FROM Table1 UPDATE Table2 SET Score = (Table2.BadTokens / @BadMails) / ((Table2.BadTokens / @BadMails) + (Table2.GoodTokens / @GoodMails))

Here's where I started way back when... Professional SQL Server Development with Access 2000 by Rick Dobson, Published by Wrox Press Ltd. It is primarily centered around SQL7 & Access 2K but it still all applies. Access 2002 and up have a much tighter integration with SQL 2K but the...

jockey, Set up a linked server. The easiest way is to set it up via Enterprise Manager. You can also find info in Books Online... ttba

Here's an article on dynamic pivot tables that may be of help: http://www.sqlteam.com/item.asp?ItemID=2955

JoeHank, Coule of things here. First, you don't need to set the focus to the combo box to read from it. The only time you do is if you try to read from combo0.text. If it doesn't have the focus you can get data by simply reading from combo0.value or Me.combo0. Good luck, ttba

vmon, Couple of thoughts - I assume a stored procedure... (1) Use a default value on the parameter. (2) Use an IF statement to detect the null value and fire an alternate select statement. ttba

DSect, Another alternate way of thinking about this could possibly be related to the Row_ID. If it is an identity field and always in chronological order then you could probably drum up some creative ideas sorting by Row_ID (desc for instance) and use a cursor. However, this would be...

Meny21, I Don't remember all of the limitations of SQL 7 but in SQL 2000 you have a couple of options if you are short on $$$. Perhaps SQL 7 has some of these capabilities. I'm sure some other folks can chime in for more info on the differences... First, you can install multiple instances...

DSect, How about something like this. Should be able to easily adapt it if you want to get all users rather than just one at a time. ttba CREATE PROCEDURE stp_Get_Info ( @Cust_ID INT, @DateRange nvarchar(9) ) AS SET NOCOUNT ON DECLARE @LeftYear INT, @ClosestYear INT SET @LeftYear =...

smayshar: Use a recordset and bookmark: Dim rst As Recordset Dim strCriteria strCriteria = "FieldName = " & OpenArgs With Forms!MainFormName!SubFormName.Form Set rst = .RecordsetClone rst.MoveFirst rst.Find strCriteria, , adSearchForward .Bookmark...