Search results

The SQL would look closer to: "Select Cust_ID, Sum(MCounter) where Cust_ID = ' & [Cust_ID] & "' GROUP BY Cust_ID" But if you are looking to have this be the source for a control on a form, then take a look at the DSUM function.

You already have all of the fields from Children in your recordset, r. SELECT Customers.*, SalesManagers.*, Children.* ... You should be able to just use: !ResultRetailWeek1 = !AvgRetailWeek1 * !RetailWeek1 Do you have more than one instance of the field RetailWeek1 across your referenced tables?

Sorry to throw my $.02 in here, but I gotta clean this code up a bit. Private Sub Filter_AfterUpdate() Dim WhereCls As String SELECT CASE Me![Filter] CASE "OSI": WhereCls = " WHERE [USCISProgram] = 'OSI'" CASE "FDNS": WhereCls = " WHERE [USCISProgram] = 'FDNS'" CASE "SCI": WhereCls = "...

For the majority of businesses out there not doing major e-commerce and pretty much sticking to in-house needs, I believe SQL Server is a great product. The support for it is tremendous as the user base is huge. The book I mentioned above is great even for beginners. SQL Server comes with the...

Structure is integral. Not having tables indexed correctly, having queries performing cartesian joins, nested aggregate queries ... all of this will affect the performance of your queries. I would also ask about the throughput with your webhost. You could have everything optimized but only...

Well, you need to requery your recordset to get the update from the server. OpenADORS.Open "SELECT * FROM dbo.MyTable WHERE Field2 = 'John Doe'" , objConn, adOpenDynamic, adLockOptimistic OpenADORS.AddNew OpenADORS!Field2 = "John Doe" OpenADORS.Update OpenADORS.ReQuery

First off, let's establish what the size is. If we are talking about a 5 MB database with linked tables and a 1 MB without, then let's not sweat this. There is going to be some overhead with the connection information. The size of the linked tables is not going to matter. I have tables with...

Well, I don't see why not, if you create a shortcut to the macro out in a location that the server can get to and this location also needs to have the proper rights as the account that SQL Agent is running under. This may be your issue right there. Under what account is SQL Agent running...

Well, something is always going to happen. Did you refresh the job listings? Your job should have had it's icon change to a red circle with an X in it. Right mouse click on it to view the job history and put a check in the Show Step Details box. This should tell you what is wrong. Also...

For SQL, Inside SQL Server is a good book. Very straightforward with their explanations. As far a tutorials, no. When I started this whole DB thing, I just jumped in by creating a DB that tracked all of my contacts. Personal ... professional ... whatever. Created queries, forms ...

That is funny.

Well ... first off, I have to ask why you are using variables and temp tables for such a simple process ... select Students, Sum(Scores) Total, from members where Students = 'Amy' group by Students Anyhow, you can't use global temp tables in data transformations, which, if you think about it...

Huh, this is news to me. Do you have any documentation to support this? Have you tried doing a compact & repair after linking and before making your MDE file? Have you tried doing a compact & repair AFTER making your MDE file? I am a DBA at my company and I monitor the connection very...

Not sure ... This works fine for me, does it for you? declare @ForYear Int select @ForYear = '06' select Convert(DateTime, '01-Oct-' + Convert(VarChar, @ForYear)) What is your call to this proc?

Single # temp tables are dropped with the connection, double # (Global Temp Tables) are seen by all connections and stay alive until they are dropped. Both reside in the tempdb database. if exists(select * from tempdb.dbo.sysobjects where Name Like '##tbl%') drop table ##tbl

That is why I am looking for some personal experience.

Hello all, My Father has always wanted to take his boys (2) fishing up in Ontario, but we have never gotten around to it. This spring, we are determined to make it happen and I am starting my research as to the best lake/resort to go to. Not looking for a fly-in as my Father is now 80 years...

Funny, I just had to do this yesterday. ... & Replace(Me!Person_Responsible, "'", "''") & ... You have to replace the single quote with two single quotes.

Ah string manipulation. One of my favs. But, as you can see from my example, do you realy want. The last line or the last sentence. Some people define this as the same, so I will include both here. I have a table named Tbl_Mem with a memo field named MemField. Some have hard breaks, others...

When you say recognize, do you mean that you are clicking on the dropdown and it isn't there, or you have typed in the name of the server and it says it doesn't exist? You may/will have to type it in the first time ...