Search results

You'll need to write a concatenate function. Read this and then post with any follow-up questions you may have: http://allenbrowne.com/func-concat.html

The sample I submitted to you does contain a sub-query.

Adam, That will only work if the maximum GPA is unique to a given major.

This is totally off the top of my head, untested, etc. It is your job to verify it works, troubleshoot, squash bugs: SELECT a.StdMajor,a.StdNo,a.StdFirstName,a.StdLastName,a.StdGPA from student a inner join (Select StdMajor,MAX(StdGPA ) as maxgpa from student GROUP BY Stdmajor) b on a...

select y.Lote, count(*) from (select left(Lote,3) as Lote from BASE) as y group by y.Lote Put it into the Row Source property (after careful testing & debugging). You might want to test it out as a query first (just paste it into the SQL window of a new query) and then use that query in the...

Are these numbers in a field on a table or in a file? Where do they come from? If in a table: select y.x, count(*) from ( select left(columnname,3) as x from mytablename ) as y group by y.x is one of many ways to accomplish this if the data is in a table. Otherwise, you'll need to iterate...

Is that why witches have familiars?

I think he answered the question incredibly accurately.

Hi Tess, You make me feel good. Gratz! I (unfortunately) had to sell my home in Tampa as a short sale. You got the gist of it right. The mortgage holder has to agree to the terms of the contract and releases the debtor from further obligation. In my case, the lender asked that I pay an...

NP. I noticed that while I was reformatting your code. You probably were getting millions of rows from your query.

Do you have indexes on the tables? Which table is bigger? You'll need to evaluate whether it would be best to put an index on nandat.art or sample_id/area_id/sample_id, or some combination of all 3. At any rate, all columns in your where clause are candidates for an index. You might consider...

It took me months to get her on FB and she only looks at it once a week. She just hates computers.

She played Guitar Hero with my son and enjoyed it. She wouldn't even attempt playing WoW with me. The last game I got her to play was either Cosmo's Cosmic Adventures or Tetris (back in the early '90s).

I tried that with her recently. She complained that I never suggested anything we could do together. So I asked her the following week to play WoW with me. It didn't go as well as I had hoped.

Then, as I understand it, you are putting a GuardianID in to the Students table and it is changing against your/the user's will?

Yeah, something like that. What's really pathetic is that you can now get 3rd party add ons for WoW so you can play puzzle games while you're playing WoW. My son does this ALL the time and his party members have to get on to him for not paying attention to the game ("are you playing Bejewelled...

Best: Zelda OOT Most hours logged: World of Warcraft Also spent a lot of time playing Runescape with my son but that was while I was out of town a lot and before we discovered WoW. I totally enjoyed many of the games on C64 back in the day. Many were simple but very fun. I also have a...

So, you're saying that GuardianID is a single field in Student and you're able to assign a student to a guardian but that (Student) record does not have the correct GuardianID?

Your database is not properly normalized. You need to consider adding a junction or associative table between Guardian & Student, enforcing a M:M relationship.

Welcome, Nate...thanks for serving!