Search results for query: *

I have a table of people who move rooms. Every time they change rooms, the room gets updated along with a transfer date. I am trying make a query that will return only the record with the most recent transfer date. Can anyone point me in the right direction? Thanks! Greg

Crystal enterprise is a freakin' pain. It is almost easier to go back to all the MS Access reports I have. I will check this out. Thanks!

thanks! I'll check that out. I don't have a problem with VB. I managed to get Crystal enterprise running but it is a little clunky and awkward. I would like to be able to just add reports as a palette item or something. I will check out the vb way today and see where it gets me. thanks again!

Crystal 10 came with a CD for Crystal enterprise 10. Is that the web deployment CD you are talking about? I have not given it much of a look but that it seems to have somehting to do with deploying reports on a web server

I have Crystal Reports 10 and have made several reports with it to run aginast my Great Plains companies. The reports run great, the problem is that I am the only one who can run them because I am the only one with Crystal on my computer. It's getting old runnning more and more of these for...

perfect! Thanks. Greg

Can someone point me to a thread or link on working with Temp tables? I saw one on here a while back but can't find it anymore. I have been searching but found nothing. Thanks! Greh

We use GFI Mail Essentials here for Anti-spam and it works great. It stops most but not all of it. One or two still sneak thgough. Lots of power and flexibility plus good support and support forums. greese

So it's a bigger 100mbps connection and not really a faster one from a pure speed standpoint. I have my database servers, terminal servers, file servers etc setup this way. So it is normal to see the speed reported by Windows as 100mbps. Good to know. Thanks! greg

I have a Cisco Catalyst 2948G switch. My servers have dual intel nics that are capable of running as an FEC team. I think i have everything setup right. The intel software says the nics are running as an FEC team, but the properties say it is running at 100mbps. Shouldn't it be 200mbps? I...

Thanks! That did the trick and i think am now on the right path. I knew there had to be an easier way then how i was doing it. G Reese

perfect. Except i made a mistake. It was supposed to be mmddyy Does the same method handle that as well? Thanks! G Reese

I am exporting the date along with results from my table my table but need it in the format yymmdd 12/17/2003 becomes 031203. To test this out, i have the following: Declare @dtYear varchar(2) Declare @dtMonth varchar (2) Declare @dtDay varchar (2) set @dtYear = right (Datepart(yyyy...